oracle 数据插入

1、插入完整行

格式：insert into table（

xxx_id,

xxx_name,

……

xxx_address)

valus(

'xxxxxx',

'xxxxxx',

……

'xxxxxx');

示例：

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 into table1（

xxx_id,

xxx_name,

……

xxx_address

select

xxx_id,

xxx_name,

……

xxx_address

from table2；

示例：

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

备注：1、table2检索出的数据插入到table1，必须先把table2表做填充。

2、table2的检索出的值，不能存在table1中，否则提示插入不成功。