Oracle data insertion

1. Insert the complete line

insert into table (

xxx_id,

xxx_name,

……

xxx_address)

valus(

'xxxxxx',

'xxxxxx',

……

'xxxxxx');

Examples:

insert into custnew (

cust_id,

cust_name,

cust_address,

cust_city,

cust_state,

cust_zip,

cust_country,

cust_contact,

cust_email)

values(

'1000000008',

'zhang',

'shitonglu street',

'shijiazhuang',

'sjz',

'3333',

'china',

'sun',

'10110@126.com');

2. Insert retrieved data

insert into table1（

xxx_id,

xxx_name,

……

xxx_address

select

xxx_id,

xxx_name,

……

xxx_address

from table2;

Examples:

insert into customers (

cust_id,

cust_name,

cust_address,

cust_city,

cust_state,

cust_zip,

cust_country,

cust_contact,

cust_email)

select cust_id,

cust_name,

cust_address,

cust_city,

cust_state,

cust_zip,

cust_country,

cust_contact,

cust_email

from custnew

Note: The retrieved data from table 1 and table2 must be inserted into table1, and table2 must be filled first.

2. The retrieved value of table2 cannot exist in table1, otherwise the insertion is unsuccessful.