Difference between creating a table in DB2 and creating an Oracle database

If you want to create a table with a structure similar to a known table in db2, you can use: (1) createtableaasselect * frombwhere1lt; gt; 1; ---- only create a table

In db2, if you want to create a table with a known table structure, you can use: (1) create table a as select * from B where 1lt; gt; 1; ---- only create a table

If you want to create a table with a known table structure in db2, you can use:

(1) create table a as select * from B where 1 <> 1; ---- only create a table without importing data.

(2) create table a as select * from B ---- create table a, and copy the data in table B to the table a to be created.

(3) create table a as select a, B, c, d, e from B where 1 <> 1 ---- create table a, table structure and a, B, c, the five columns d and e are consistent and do not contain table data.

To complete similar tasks in db2, run the following statement.

(1) create table a like B;

(2) create table a like B;

Insert into a (select * from B );

(3) create table a as (select a, B, c, d, e from B) definition only;