[교육] SQL초보에서실전전문가까지 ORACLE - 7 DECENDING INDEX CREATE INDEX fidx_stud_no_name ON student (deptno DESC, name ASC); 함수기반 INDEX CREATE INDEX fidx_stud_no_name ON student (UPPER(ename)); 실행계획보기 [oracle@localhost ~]$ cd $ORACLE_HOME/sqlplus/admin [oracle@localhost admin]$ ls glogin.sql help iplus plustrce.sql pupbld.sql [oracle@localhost admin]$ pwd /u01/app/oracle/product/10.2.0/db_1/sqlplus/admin [oracle@localhost admin]$ ls -al.. 더보기 [교육] SQL초보에서실전전문가까지 ORACLE - 6 --// MERGE SAMPLESCREATE TABLE TESTAS SELECT * FROM EMP WHERE DEPTNO=10; SELECT * FROM TEST; UPDATE TEST SET SAL = SAL+1000; SELECT * FROM TEST;SELECT * FROM EMP; MERGE INTO TEST TUSING EMP EON (T.EMPNO = E.EMPNO)WHEN MATCHED THENUPDATE SET T.SAL = E.SALWHEN NOT MATCHED THENINSERT VALUES(E.EMPNO, E.ENAME, E.JOB, E.MGR, E.HIREDATE, E.SAL, E.COMM, E.DEPTNO); DROP TABLE TEST; --// SELECT INTO 구분의 차.. 더보기 이전 1 ··· 14 15 16 17 18 19 20 ··· 40 다음