by Nathan

Oracle Create Table 본문

Programming/SQL

Oracle Create Table

넷쓴 2018. 8. 13. 10:21



1
2
3
4
5
6
7
8
CREATE TABLE ABC_TABLE(
    AAA VARCHAR2(10NOT NULL,
    BBB NUMBER(2,0NOT NULL,
    HTML CLOB NOT NULL,
    REGDATE VARCHAR2(14DEFAULT TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'),
    MODDATE VARCHAR2(14DEFAULT TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'),
    CONSTRAINT PK_ABC_TABLE PRIMARY KEY(AAA, BBB)
);
cs


'Programming > SQL' 카테고리의 다른 글

MERGE INTO 구문  (0) 2018.08.20
Comments