![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
plsql
lantian000
这个作者很懒,什么都没留下…
展开
-
oracle ANY SOME ALL
1)TEST2表: 2)查询如下语句: 3)ALL, SOME, ANY 用于将值与子查询返回的值列表或结果集进行比较 4)以下转载自https://www.cnblogs.com/youseiraws/p/8602328.html SELECT * FROM table_name WHERE c > ALL ( v1, v2, v3 ); -- 以上语句转换为 ALL 运算符后 SELECT原创 2021-04-22 23:40:37 · 130 阅读 · 0 评论 -
sqlplus spool
在.sql文件里写入: set echo on; select * from test2; set trimspool off; select * from test2; set echo off; prompt *** spool to sys_user.txt spool c:/sys_user.txt; set timing on; set trimout on; set colsep '|'; set heading off; select * from test2; spool off; 保存原创 2021-03-23 23:12:24 · 202 阅读 · 0 评论 -
oracle 游标遇到的问题
1) 执行代码: declare cursor s is select priv from test2; cur_tst varchar2(1); begin open s; loop exit when s%notfound; fetch s into cur_tst; --exit when s%notfound; dbms_output.put_line(cur_tst); end loop; close s; exception ...原创 2021-03-22 23:16:52 · 247 阅读 · 0 评论