by Nathan
Oracle Create Table
12345678CREATE 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));Colored by Color Scriptercs
Programming/SQL
2018. 8. 13. 10:21