by Nathan
Oracle Create Table 본문
1 2 3 4 5 6 7 8 | CREATE TABLE ABC_TABLE( AAA VARCHAR2(10) NOT NULL, BBB NUMBER(2,0) NOT NULL, HTML CLOB NOT NULL, REGDATE VARCHAR2(14) DEFAULT TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), MODDATE VARCHAR2(14) DEFAULT TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), CONSTRAINT PK_ABC_TABLE PRIMARY KEY(AAA, BBB) ); | cs |
'Programming > SQL' 카테고리의 다른 글
MERGE INTO 구문 (0) | 2018.08.20 |
---|
Comments