개발/데이타베이스39 오라클 테이블 복사 [테이블 복사하기 스키마 데이터] CREATE TABLE 새로만들테이블명 AS SELECT * FROM 복사할테이블명 [WHERE 절] [테이블 구조만 복사하기] CREATE TABLE 새로만들테이블명 AS SELECT * FROM 복사할테이블명 WHERE 1=2 [where에다가 참이 아닌 조건을 넣어줌] 2016. 11. 28. oracle auto increment CREATE SEQUENCE product_list_seq START WITH 1 INCREMENT BY 1; CREATE OR REPLACE TRIGGER product_list_triggerBEFORE INSERT ON PRODUCT_LISTREFERENCING NEW AS NEWFOR EACH ROWBEGIN SELECT product_list_seq.nextval INTO :NEW.ID FROM dual;END; 기타, 오라클 버전 확인, SELECT * FROM v$version WHERE banner LIKE 'Oracle%'; 2016. 11. 28. group by, orderby, multiple column [group by] Group By X means put all those with the same value for X in the one group.Group By X, Y means put all those with the same values for both X and Y in the one group.To illustrate using an example, let's say we have the following table, to do with who is attending what subject at a university:Table: Subject_Selection Subject Semester Attendee --------------------------------- ITB001 1 Jo.. 2016. 11. 11. ORACLE LEFT OUTER JOIN SELECT * FROM(SELECT * FROM A WHERE COL_A= 'A') ALEFT OUTER JOIN(SELECT * FROM B WHERE COL_B= 'B') BON A.FK = B.PK; 이 쿼리는 아래 ORACLE 쿼리와 동등하다. SELECT * FROM(SELECT * FROM A WHERE COL_A= 'A') A,(SELECT * FROM B WHERE COL_B= 'B') BWHERE A.FK = B.PK(+); FROM : http://nown2210.tistory.com/14 2016. 11. 8. 이전 1 ··· 6 7 8 9 10 다음