Oracle: A table has four columns, the new watch is B, want to make A copy of the first two columns of A table to table B should do

CodePudding user response:

Direct point can:
Insert into B select col1, col2 from A;

CodePudding user response:

reference 1st floor dbs_service response:

can direct point:
Insert into B select col1, col2 from A;

col1 and col2 is what meaning, you can directly use the

CodePudding user response:

Col1 and col2 on behalf of the first and second column

CodePudding user response:

refer to the second floor weixin_44254255 response:

Quote: refer to 1st floor dbs_service response:

can direct point:
Insert into B select col1, col2 from A;

col1 and col2 is what meaning, you can directly use the

Col1, col2 represents 1, column 2 of the property name, behind is a select statement,

CodePudding user response:

It should be more table insert concept