关联式资料查询FncinsandGrp.pptVIP

關聯式資料查詢 Functions and Group Sub Query Join Data View 內建函式介紹 Oracle內建函式分類 Character Function SQL SELECT LOWER(Hello World!) FROM DUAL ; SQL SELECT UPPER(Hello World!) FROM DUAL ; SQL SELECT INITCAP(Hello World!) FROM DUAL ; SQL SELECT CONCAT(Hello, World!) FROM DUAL ; SQL SELECT SUBSTR(Hello World!, 1, 5) FROM DUAL ; SQL SELECT SUBSTR(Hello World!, -5, 3) FROM DUAL ; SQL SELECT LENGTH(Hello World!) FROM DUAL ; SQL SELECT INSTR(Hello World!, W) FROM DUAL ; SQL SELECT TRIM(H FROM Hello World!) FROM DUAL ; SQL SELECT LPAD(sal, 10, *) FROM emp ; SQL SELECT RPAD(sal, 10, *) FROM emp ; SQL SELECT en