select..into is part of PL/SQL language which means you have to use it inside a PL/SQL block. You can not use it in a SQL statement outside of PL/SQL.
select into 的是一个值，而不是一个记录集
http://www.itpub.net/251630.html
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/77164/viewspace-1008289/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- ORA-23515: 实体化视图和/或它们的索引存在于表空间中
- rac 缺失本地节点node1的信息
- ORA-01287 from a different database incarnation
- ORA-07445: exception encountered: [Address not mapped to object]
- ORA-06544: PL/SQL: internal error, arguments: [56319]
- ORA-01031 insufficient privileges
- ORA-00314: log 2 of thread 1, expected sequence# 53 doesn't match 2
- ORA-00600: internal error code, arguments: [4193],
- ORA-00313: open failed for members of log group
- ORA-01552: cannot use system rollback segment
