SQL부스터 썸네일형 리스트형 ORACLE 12C 테이블 생성 CREATE TABLE C_BAS_CD( BAS_CD_DV VARCHAR2(40) NOT NULL, LNG_CD VARCHAR2(40) NOT NULL, BAS_CD VARCHAR2(40) NOT NULL, BAS_CD_NM VARCHAR2(100) NULL, SRT_OD NUMBER(18) NULL ); CREATE UNIQUE INDEX PK_C_BAS_CD ON C_BAS_CD(BAS_CD_DV ASC, LNG_CD ASC, BAS_CD ASC); ALTER TABLE C_BAS_CD ADD CONSTRAINT PK_C_BAS_CD PRIMARY KEY(BAS_CD_DV,LNG_CD,BAS_CD); CREATE TABLE C_BAS_CD_DV( BAS_CD_DV VARCHAR2(40) NOT NUL.. 더보기 ORACLE 12c 사용자 계정 생성 //아이디생성 CREATE USER C##ORA_SQL_TEST IDENTIFIED BY "1QAZ2WSX"; //권한부여 GRANT ALTER SYSTEM TO C##ORA_SQL_TEST; GRANT CONNECT, RESOURCE TO C##ORA_SQL_TEST; GRANT ALTER SYSTEM TO C##ORA_SQL_TEST; GRANT SELECT ON V_$C##ORA_SQL_TEST; GRANT SELECT ON V_$SQL_PLAN_STATISTICS_ALL TO C##ORA_SQL_TEST; GRANT SELECT ON V_$SESSION TO C##ORA_SQL_TEST; GRANT EXECUTE ON DBMS_STATS TO C##ORA_SQL_TEST; GRANT SELECT .. 더보기 이전 1 다음
