본문 바로가기

삭제3

[SQL]시퀀스 만들기(생성,확인,실행,수정,삭제,동의어) /*시퀀스 만들기*/ CREATE SEQUENCE SEQ_DEPT_SEQUENCE INCREMENT BY 10 START WITH 10 MAXVALUE 90 MINVALUE 0 NOCYCLE CACHE 2; SELECT * FROM USER_SEQUENCES; INSERT INTO DEPT_SEQUENCE (DEPTNO,DNAME,LOC) VALUES (SEQ_DEPT_SEQUENCE.NEXTVAL,'DATABASE','SEOUL'); SELECT * FROM DEPT_SEQUENCE ORDER BY DEPTNO; /*가장 마지막으로 생성된 시퀀스 확인*/ SELECT SEQ_DEPT_SEQUENCE.CURRVAL FROM DUAL; /*순번을 반복사용하여 INSERT문 실행*/ INSERT INTO D.. 2020. 6. 11.
[SQL]ROLLBACK,세션,RENAME,MODIFY,INDEX(생성,삭제),VIEW,인라인뷰(WITH절) /*01.삽입*/ INSERT INTO DEPT_TCL VALUES (50,'DATABASE','SEOUL'); /*02.수정*/ UPDATE DEPT_TCL SET LOC = 'BUSAN' WHERE DEPTNO = 40; /*03.삭제*/ DELETE FROM DEPT_TCL WHERE DNAME='RESEARCH'; COMMIT; ROLLBACK; /*P277 테이블에 있는 데이터 수정하기*/ SELECT * FROM DEPT_TEMP2; /* UPDATE SET */ UPDATE DEPT_TEMP2 SET LOC='SEOUL'; /* 수정작업을 되돌리고 싶을 때 ROLLBACK*/ ROLLBACK; /* DELETE FROM */ SELECT * FROM EMP_TEMP2; DELETE FROM .. 2020. 6. 11.
[SQL]테이블 확인,생성,삭제,삽입 /*테이블 확인*/ SELECT * FROM TAB; SELECT * FROM TABS; /*테이블 생성*/ CREATE TABLE DEPT_TEMP AS SELECT * FROM DEPT; /*테이블 삭제*/ DROP TABLE DEPT_TEMP; /*데이터 삽입 */ INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC) VALUES (50,'DATABASE','SEOUL'); /* NULL데이터 삽입*/ INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC) VALUES (70,'WEB',NULL); INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC) VALUES (80,'MOBILE',''); INSERT INTO DEPT_TEMP (DEP.. 2020. 6. 11.

티스토리툴바