Table Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Table
  4. 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.