Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Create a table with primary key, VARCHAR type column and date type column with default value

CREATE TABLE myTable (           2    id INTEGER PRIMARY KEY,   3    status VARCHAR2(10),   4    last_modified DATE DEFAULT SYSDATE   5  ); Table created. SQL> SQL> desc myTable;  Name              Null?    Type  ID                NOT NULL NUMBER(38)  STATUS                     VARCHAR2(10)  LAST_MODIFIED                                                                                                                                                                  DATE SQL> SQL> drop table myTable; Table dropped.