Create a table with primary key, VARCHAR type column and date type column with default value : Primary Key « Table « Oracle PL/SQL Tutorial

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.

6.15.Primary Key
	6.15.1.	Create a table with primary key, VARCHAR type column and date type column with default value
	6.15.2.	Alter table to insert primary key
	6.15.3.	Use combined column as the primary key
	6.15.4.	Try to add two primary keys to one table
	6.15.5.	All columns as primary key
	6.15.6.	One to many using a primary-key and foreign-key relationship
	6.15.7.	One-to-one using a primary-key and foreign-key relationship
	6.15.8.	Use three columns as primary key