Create table with primary key : Copy Table « Table « Oracle PL/SQL Tutorial






SQL> create table myTable (
  2    word  varchar2(50),
  3    position   int,
  4    doc_id int,
  5    primary key(word,position,doc_id)
  6  );

Table created.

SQL>
SQL>
SQL>
SQL> drop table myTable;

Table dropped.








6.4.Copy Table
6.4.1.Create a copy table
6.4.2.Create table with primary key
6.4.3.Copy table with adding the primary key
6.4.4.Create a table by copy certain rows
6.4.5.Create a copy table and aggregate function
6.4.6.Create a copy by select specific columns
6.4.7.Copying table structure not data