insert into REC_OVER(ORG_ID) select '1' from dual where not

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/17 05:45:27

insert into REC_OVER(ORG_ID) select '1' from dual where not exists (select ORG_ID from REC_OVER )
insert into REC_OVER(ORG_ID) select '1' from dual where not exists (select ORG_ID from REC_OVER )
请问oracle里这样的语句,为什么在sql/plus可以正常,就是当REC_OVER表没有记录的时候就添加,但是用jsp执行的时候,总是认为不能添加呢,不管表REC_OVER有没有记录都不添加,改成：insert into REC_OVER(ORG_ID) select '1' from dual where exists (select ORG_ID from REC_OVER ) 的话,就不管什么情况下都会添加.

你这个语句说白了跟dual 就没有关系
你的目的就是当REC_OVER 没有数据的时候添加一个ORG_ID=1
可以这样写
insert into REC_OVER(ORG_ID)
select '1' where (select count（ORG_ID） from REC_OVER ) =0

insert into REC_OVER(ORG_ID) select '1' from dual where not insert into a select * from b 和select * into a from b 这两个语句是数据库中select into from 和 insert into select的区别 select Insert into和Insert into select的区别 select * into b from a where 11 insert into a (select * from b)和把记录取出来然后分别insert那个的效率高? insert into select 语句,需要多insert一个字段怎么办 select count() into :r_count from zw_kmyeb where km_code lik select hkont from bseg into table itab_bseg where ( hkont li select * from book where 1=1 if not exists(select 1 from sysobjects where type='U' and na if not exists (SELECT * From TA_ARTIFICER Where ARTID = @Art