请教如何去掉查询结果后面的行数?
例如查询结果有25条,sqlplus后面会输出 25 rows selected。
如何去掉这个显示?
------解决方案--------------------set feedback off
示例如下:
SQL> select * from fky where rownum <= 5;
AA
--------------------------------------------
2013-08-21 15:44:37 hello world fky !
2013-08-21 15:44:47 hello world gloria !
2013-08-21 15:44:57 hello world pwd !
2013-08-21 15:45:22 hello world &'2 !
2013-08-21 15:46:38 hello world ! 3
SQL> set feedback off
SQL> select * from fky where rownum <= 5;
AA
--------------------------------------------
2013-08-21 15:44:37 hello world fky !
2013-08-21 15:44:47 hello world gloria !
2013-08-21 15:44:57 hello world pwd !
2013-08-21 15:45:22 hello world &'2 !
2013-08-21 15:46:38 hello world ! 3
SQL>
------解决方案--------------------set feedback off;