OraFAQ Forum: SQL & PL/SQL » question about "set termout off" and "java stored procedure "

Home » SQL & PL/SQL » SQL & PL/SQL » question about "set termout off" and "java stored procedure "

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

question about "set termout off" and "java stored procedure " [message #192943]

Thu, 14 September 2006 05:53

m_arafa
Messages: 36
Registered: June 2006

Member

hi all,

- what the benefit from using : set termout off
with example please

- i want to know about java stored procedure or any thing about java .......

Report message to a moderator

Re: question about "set termout off" and "java stored procedure " [message #192948 is a reply to message #192943]

Thu, 14 September 2006 06:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SET TERMOUT OFF suppresses the display sou you can spool output from a command file without displaying the output. Therefore, it makes spooling process faster as it doesn't have to waste time for displaying purposes; it isn't that noticeable when the output is relatively small, but - for large files - it may make a difference.

Example? Create a query which produces a huge output. Then measure time with TERMOUT ON and TERMOUT OFF, and compare those values.

Java is an island of Indonesia.
Just kidding ... I don't know anything about it, so - wait for another answer.

Report message to a moderator