作者热门文章
- Java 双重比较
- java - 比较器与 Apache BeanComparator
- Objective-C 完成 block 导致额外的方法调用?
- database - RESTful URI 是否应该公开数据库主键?
我有两个表 Alpha_Setting
和 Beta_View
如下所示,
Alpha_Setting
:
ID ( Sequence )
VIEW_ID
VIEW_TYPE
VIEW_VALUE
Beta_View
ID
VIEW_NAME
VIEW_TYPE
VIEW_CHECK
我想在 Alpha_Setting
中将 Beta_View
中的多个 ID 插入到 VIEW_ID
中,我应该如何更正我的 SQL
insert into alpha_setting
('',
(select ID from beta_view where view_type = 'HERO' and (view_name = 'GREEN-All' or view_name = 'GREEN-New'),
'super_power',
'1000000');
最佳答案
试试这个方法:
insert into alpha_setting (ID,VIEW_ID,VIEW_TYPE,VIEW_VALUE)
select '' /* or seq_name.nextval*/, ID,'super_power','1000000'
from beta_view
where view_type = 'HERO'
and view_name in('GREEN-All','GREEN-New','super_power','1000000');
或
insert into alpha_setting (ID,VIEW_ID,VIEW_TYPE,VIEW_VALUE)
select '' /* or seq_name.nextval*/, ID,'super_power','1000000'
from beta_view
where view_type = 'HERO'
and (view_name = 'GREEN-All' or view_name in('GREEN-New','super_power','1000000'));
我不确定 view_name
列的哪种情况适合您。
关于sql - Oracle SQL 多表插入语句,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/18344403/
我是一名优秀的程序员,十分优秀!