Home » SQL & PL/SQL » SQL & PL/SQL » question about "set termout off" and "java stored procedure "
question about "set termout off" and "java stored procedure " [message #192943] Thu, 14 September 2006 05:53 Go to next message
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 .......
Re: question about "set termout off" and "java stored procedure " [message #192948 is a reply to message #192943] Thu, 14 September 2006 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: question about "set termout off" and "java stored procedure " [message #193420 is a reply to message #192948] Sat, 16 September 2006 10:03 Go to previous messageGo to next message
m_arafa
Messages: 36
Registered: June 2006
Member
thanx Littlefoot

i want anyone give me advice about ....

i want to learning java are it useful with me
and to build applications with oracle

Re: question about "set termout off" and "java stored procedure " [message #193463 is a reply to message #192943] Sun, 17 September 2006 06:47 Go to previous message
hobbes
Messages: 173
Registered: January 2006
Senior Member
Sun's Java Tutorial is a good place to start.
Previous Topic: UTL_FILE extract to multiple files
Next Topic: Where is my table stored?
Goto Forum:
  


Current Time: Fri Dec 09 23:36:58 CST 2016

Total time taken to generate the page: 0.10328 seconds