insert into bt_field_enum(fld_enum_id,fld_exp_id,parent_enum_value,enum_value,enum_name, enum_level,enum_desc,enum_status,use_frequency,enum_order) select seq_fld_enum_id.nexval as ,205,parent_enum_value,enum_value,enum_name,enum_level,enum_desc,enum_status, use_frequency,enum_order from jsyd.t_field_enum INSERT INTO的时候,可以直接使用SELECT ,不使用VALUES
不需要用子查询,直接 seq_fld_enum_id.nexval 就可以了。
insert into bt_field_enum (fld_enum_id,fld_exp_id,parent_enum_value,enum_value,enum_name, enum_level,enum_desc,enum_status,use_frequency,enum_order) select seq_fld_enum_id.nexval,205,parent_enum_value,enum_value,enum_name,enum_level,enum_desc,enum_status, use_frequency,enum_order from jsyd.t_field_enum
看看这个,自己测试下 insert into bt_field_enum(fld_enum_id,fld_exp_id,parent_enum_value,enum_value,enum_name, enum_level,enum_desc,enum_status,use_frequency,enum_order) select seq_fld_enum_id.nexval,205,parent_enum_value,enum_value,enum_name, enum_level,enum_desc,enum_status,use_frequency,enum_order from (select parent_enum_value,enum_value,enum_name,enum_level,enum_desc,enum_status, use_frequency,enum_order from jsyd.t_field_enum);
可以直接在用集合插入方式 insert into table (,,,) select * from table
enum_level,enum_desc,enum_status,use_frequency,enum_order) select seq_fld_enum_id.nexval as ,205,parent_enum_value,enum_value,enum_name,enum_level,enum_desc,enum_status,
use_frequency,enum_order from jsyd.t_field_enum
INSERT INTO的时候,可以直接使用SELECT ,不使用VALUES
(fld_enum_id,fld_exp_id,parent_enum_value,enum_value,enum_name,
enum_level,enum_desc,enum_status,use_frequency,enum_order)
select seq_fld_enum_id.nexval,205,parent_enum_value,enum_value,enum_name,enum_level,enum_desc,enum_status,
use_frequency,enum_order from jsyd.t_field_enum
insert into bt_field_enum(fld_enum_id,fld_exp_id,parent_enum_value,enum_value,enum_name,
enum_level,enum_desc,enum_status,use_frequency,enum_order)
select seq_fld_enum_id.nexval,205,parent_enum_value,enum_value,enum_name,
enum_level,enum_desc,enum_status,use_frequency,enum_order
from (select parent_enum_value,enum_value,enum_name,enum_level,enum_desc,enum_status,
use_frequency,enum_order
from jsyd.t_field_enum);