lantian000的博客

1）TEST2表：2）查询如下语句：3）ALL, SOME, ANY 用于将值与子查询返回的值列表或结果集进行比较4）以下转载自https://www.cnblogs.com/youseiraws/p/8602328.htmlSELECT *FROM table_nameWHERE c > ALL ( v1, v2, v3 );-- 以上语句转换为 ALL 运算符后SELECT

在.sql文件里写入：set echo on;select * from test2;set trimspool off;select * from test2;set echo off;prompt *** spool to sys_user.txtspool c:/sys_user.txt;set timing on;set trimout on;set colsep '|';set heading off;select * from test2;spool off;保存

1） 执行代码：declarecursor 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 ...