ORACLE_SPOOL

Question:When you use developer tool in oracle.However,you press Ctrl and click left-mouse in a table.It isn't show table attribution.

solution one:Open a new command windows.then you input following comnad;

  desc table_name;

then you copy the content into text editor.

solution two:you can use the spool command as the follow step.

  1.spool   record.txt

  2.desc table_name

  3.spool off

Queston:When you multi talbe association qery data in oracle you want use developer tool change data in the databse.

Passed my verfity with rowid in the multi table association query,it is can't modify data in the tables.

原文地址:https://www.cnblogs.com/yjhlsbnf/p/7795076.html