테이블 생성
--< 테이블생성/삭제/PK/코멘트/롤/권한 부여 > - DROP TABLE IGWOWN. XXX CASCADE CONSTRAINTS; CREATE TABLE IGWOWN. XXX FRMR_ MNG_NO AGESON_MNG _NO VLD_DT audit cols RGTR_ID REG_DT MDFR ID MDFCN_ DT VARCHAR2(10 BYTE) NUMBER (22) DATE NOT NULL, NOT NULL, NOT NULL, VARCHAR2 (100 BYTE) DATE VARCHAR2(100 BYTE) DATE NOT NULL, DEFAULT SYSDATE NOT NULL, DEFAULT SYSDATE TABLESPACE TS_ ) - 테이블 코멘트 CONHENT ON TABLE IGMOMN.XOK IS 'AB_농업이지원패스내역'; ~ 걸림 코멘트 CONHENT ON COLUNN IGMONN•100K. FRIR MNG_NO IS 농업인관리번호 '; - PK 생성1-UNIOUE INDEX 생성 CREATE UNIQUE INDEX IGWOWN. PK_ XXX ON IGMOMN. 테이블명 (컬럼1, 컬럼2) TABLESPACE TS_명 5 - PK 생성2-PK 제약조건 지정 ALTER TABLE IGWOWN-XXX ADD ( CONSTRAINT PKXOOK PRIMARY KEY (럼1, 컬럼2) 1 USING INDEX IGWOWN. PK_XXX); 2 3 -시노님 생성 4 CREATE OR REPLACE PUBLIC SYNONYM XXX FOR IGWOWN. XXX; 5 6 7 18 19 -- 롤에 권부여 GRANT DELETE, INSERT, SELECT, UPDATE ON IGWOWN, XXX TO RL_ABALL; GRANT DELETE, INSERT, SELECT, UPDATE ON IGWOWN, XXX TO RL_IGWALL; GRANT SELECT ON IGWOWN.XXX TO RL_IGWSEL;