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可

来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/26 03:13:59
insertintoREC_OVER(ORG_ID)select''1''fromdualwherenotexists(selectORG_IDfromREC_OVER)insertintoREC_OVE

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可
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 ) 的话,就不管什么情况下都会添加.

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可
你这个语句说白了跟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 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可 ADO如何使用Insert into语法 ADO如何使用Insert into语法 Insert pleasr insert game compact disc into your drive 撒意思 sql中 insert 和 insert into 的区别有看到INSERT INTO TABLE VALUES('','',...)和INSERT TABLE (栏位1,栏位2...)VALUES ('','',...)请问各位有没人知道,这2种写法有什么区别吗? insert into a (select * from b)和把记录取出来然后分别insert那个的效率高? 数据库中select into from 和 insert into select的区别 mysql 有关 insert into set的问题我想知道 INSERT INTO tablename SET 字段名=字段值,与 insert into tablename('字段名') value('字段值'),他们之间的区别,还有优缺点!但是请不要胡说, insert into 数据库插入问题今天看到这么个数据库 插入语句 平时都是insert into table (field1,field2) values (value1,value2)今天看到 insert into table set field1 = value1,fiedl2 = value2这两个有什么区别吗? INSERT INTO语法INSERT INTO Unit (unitId,unitName,fatherId,unitType) VALUES (1,'单位','0','0');INSERT INTO Users (userId,userName,Account,passWord,unitId,status) VALUES (1,'单位管理员','admin','7fa8282ad93047a4d6fe6111c93b308a','1','1');INSER Current operation(insert into database) is limited by LicenseManager unit!Current operation(insert into database) is limited by LicenseManager unit!谁帮翻译一下 insert into order_reason (reason_info,reason_id_to,company_unid) values ('第一次配送成功','第一次配送成功','78')Database error: Invalid SQL: insert into order_reason (reason_info,reason_id_to,company_unid) values ('第一次配送成功 Set rs = cn.Execute(insert into data (tcp_data) values (' & a & ')) 英语翻译:“我看见他把钥匙插入锁中.”翻译中要用到insert...into please insert the sniper art of victory disk into your drive的中文意思 Insert into语句怎么用 写详细点 谢谢如题 insert into a select * from b 和select * into a from b 这两个语句是不是一样的?