[Database] Oracle SQL문 정리
*[ 목차 ] Sequence Table & Column INSERT SELECT UPDATE DELETE JOIN *[ Sequence ] - Sequence 생성 CREATE SEQUENCE (시퀀스 이름) [INCREMENT BY n1] [START WITH n2] [MAXVALUE n3 or NOMAXVALUE] [MINVALUE n4 or NOMINVALUE] [CYCLE or NOCYCLE] [CACHE or NOCACHE]; -> increment by n : 증가값 (default 1) -> start with n : 시작값 (default 1) -> maxvalue n | nomaxvalue : 최댓값 (nomaxvalue default 10*E27) -> minvalue n | nomi..
Database
2020. 3. 2. 00:49