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 |