以前是informix数据库,下面这句代码就是查询出第一条数据 并且存放到zjlsh中
EXEC SQL SELECT FIRST 1 zjlsh INTO :zjlsh FROM reltaxreg
WHERE entrustdate=:entrustdate AND trano=:trano;现在在oracle中 我要实现同样的功能 该如何写呢?
用上面一样的代码不行 PRO*C编译报错如下
Encountered the symbol "1" when expecting one of the following: , ( * + - / . @ | an identifier, a quoted string, at, date,
into, as, count, from, day, extract, hour, interval, minute,
month, second, time, timestamp, treat, trim, year, avg, max,
min, sum, stddev, variance,
The symbol "," was substituted for "1" to continue.正确写法该怎么写呢?
EXEC SQL SELECT FIRST 1 zjlsh INTO :zjlsh FROM reltaxreg
WHERE entrustdate=:entrustdate AND trano=:trano;现在在oracle中 我要实现同样的功能 该如何写呢?
用上面一样的代码不行 PRO*C编译报错如下
Encountered the symbol "1" when expecting one of the following: , ( * + - / . @ | an identifier, a quoted string, at, date,
into, as, count, from, day, extract, hour, interval, minute,
month, second, time, timestamp, treat, trim, year, avg, max,
min, sum, stddev, variance,
The symbol "," was substituted for "1" to continue.正确写法该怎么写呢?
解决方案 »
- oracle:如何编写sql语句剔除交叉重复行
- 小城的灾难
- 求解:一个求和的 SQL
- 怎么实现把多个条件查询,写成视图,然后和表连接
- 怎么才能把图片存入ORACLE数据库并且读出来呢?用。net2.0下开发
- 大虾请进:在FR6下安装oracle 10 的问题
- 菜鸟提问:
- 关于启动OracleiSuitesManagementServer服务时的问题
- 触发器总是提示“无法从套接字读取更多数据”
- Oracle定义的字符串类型,如何像sql定义的max一样啊
- ORA-12154: TNS:无法解析指定的连接标志符和ERROR - ORA-12541: TNS:no listener 请问如何解决?
- 对比oracle两个用户之间的差异
WHERE entrustdate=:entrustdate AND trano=:trano and rownum=1;
WHERE entrustdate=:entrustdate AND trano=:trano and rownum=1;
select * from reltaxreg
where entrustdate=''
and trano=''
and rownum=1