DROP TABLE "MyUser"."MyTable";

 

CREATE TABLE "MyUser"."MyTable" (

    "number" VARCHAR2(20),

    "name" VARCHAR2(255),

    "remark" VARCHAR2(20),

    "dateTime" TIMESTAMP,

    PRIMARY KEY ("number") VALIDATE

) TABLESPACE "MyTableSpace";

 

INSERT INTO MyUser.MyTable

VALUES ('A123', 'angel', 'Fallen Angels', Sysdate);

arrow
arrow
    全站熱搜

    fabch2 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄