1.create echo.sql script with content in the following text
2.execute @/directory_path/echo.sql your can use pwd query directory or find / -name "file_name"
点击(此处)折叠或打开
- set echo on
- select ename from emp where rownum <2;
- set echo off --这后面的查询语句不会显示出来
- select dname from dept where rownum <2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31479892/viewspace-2151721/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31479892/viewspace-2151721/