[Oracle] 뷰와 시퀀스 -1-

---

2015. 7. 15. 11:24 Naver Blog 백업용

---

뷰 생성하기

 

- CREATE VIEW VIEW_NAME

 

시퀀스 생성하기

 

- CREATE SEQUENCE MYORDER_SEQ;

- DROP SEQUENCE MYORDER_SEQ;

 

- 예제

 

CREATE TABLE MYORDER(

   ORDNUM VARCHAR2(20) PRIMARY KEY,

   ORDDATE DATE,

 

   ORDID VARCHAR2(20));

 

 CREATE TABLE MYORDPRODUCT(

    ORDNUM VARCHAR2(20),

    PRDCODE VARCHAR2(20),

 

    COUNT NUMBER);

 

INSERT INTO MYORDER VALUES(MYORDER_SEQ.NEXTVAL,SYSDATE,'KIM');

INSERT INTO MYORDER VALUES(SYSDATE||'_'||MYORDER_SEQ.NEXTVAL,SYSDATE,'LEE');

SELECT * FROM MYORDER;

 

ORDNUM      ORDDATE   ORDID

----------- --------- --------

 

1           15/07/15  KIM

 

INSERT INTO MYORDPRODUCT VALUES(MYORDER_SEQ.CURRVAL,'001',1);

SELECT * FROM MYORDPRODUCT;

 

ORDNUM   PRDCODE   COUNT

------   -------   -----

 

1        001       1