oracle 在insert into的时候报ORA-00928: missing SELECT keyword错 [问题点数:100分,结帖人dm520] 转自:https://bbs.csdn.net/topics/310095274 INSERT INTO SA_Table(uniPositionCode,transferGroupName,appCode,appName,transferPort,cfg_network,transferProtocol,transferip,insideState) VALUES('01330000','1',...
ORA-00928: missing SELECT keyword, i'm not able to insert values in oracle10.2.0 table from .net2.0 ORA-01013: user requested cancel of current operation ORA-01017: invalid username/password; logon denied ORA-12154: TNS:could not resolve the connect identifier specified ORA-12504: TNS: list...
Oracle is new to me. But from the otn.oracle.com, the explaination given for your error code:
-- 注意1:with as 语句最后面不能加分号,否则报错:ORA-00928: 缺失 SELECT 关键字 -- 注意2:不能只定义with..as语句,定义了就必须要使用它,否则报错:ORA-00928: 缺失 SELECT 关键字 with temp as (select '10001' as province_code from dual) select case when (select * from temp) = '10001' the...
(OracleQuickTest.java:29) Caused by: java.sql.SQLSyntaxErrorException: ORA-00928: 缺失 SELECT 关键字 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java...