以前一直使用hibernate,差不多把SQL丢光了
现在刚好有个项目,好好的学习一把ORACLE
使用ORACLE的PL/SQL工具真的不好用
这不用上了TOAD
(PS:以前也用TOAD,不过就是简单修改一下字段)
使用不久发现无法使用 SET SERVEROUTPUT ON
GG了一下
glogin.sql is a script run automatically by SQL Plus; as far as I'm aware Toad does not run this script. In Toad there is a "DBMS Output" pane at the bottom of the Editor window, and a red button at the top left of the pane to turn output on.
原来ORACLE的SQL PLUS是自动执行glogin.sql,点一下TOAD "DBMS Output" 中的小红点,trun output on
哈
结果就出啦了
现在刚好有个项目,好好的学习一把ORACLE
使用ORACLE的PL/SQL工具真的不好用
这不用上了TOAD
(PS:以前也用TOAD,不过就是简单修改一下字段)
使用不久发现无法使用 SET SERVEROUTPUT ON
GG了一下
glogin.sql is a script run automatically by SQL Plus; as far as I'm aware Toad does not run this script. In Toad there is a "DBMS Output" pane at the bottom of the Editor window, and a red button at the top left of the pane to turn output on.
原来ORACLE的SQL PLUS是自动执行glogin.sql,点一下TOAD "DBMS Output" 中的小红点,trun output on
哈
结果就出啦了