Home » SQL & PL/SQL » Client Tools » Data load with SQL Plus - how to see the results ?
Data load with SQL Plus - how to see the results ? [message #245716] Mon, 18 June 2007 11:19 Go to next message
michael.mazuk
Messages: 14
Registered: June 2007
Junior Member
Hi,

I'm loading data in Oracle Database with SQLPlus command.

SQL> @c:\data_load.sql

1 row created
-
-
etc

Is it possible to write the results in a log file ? I can just see the result in screen but it's to fast for interprate them.

Thank you
Re: Data load with SQL Plus - how to see the results ? [message #245717 is a reply to message #245716] Mon, 18 June 2007 11:34 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
SQL> spool test.log
SQL> < ... do your stuff ... >
SQL> spool off


Thomas
Re: Data load with SQL Plus - how to see the results ? [message #245723 is a reply to message #245717] Mon, 18 June 2007 12:08 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
it's also worth knowing about pause, but it's not the most useful setting - because you need to know that it's enabled in the script to know to hit a key to get the output...


set pause on
select * from cat;


Q:    How to use "set pause" in SQL*Plus ?                                      
                                                                                
A:    For example to get 'Underlined prompt' in a VT220
      terminal use the following code in your login.sql:
      set pause <ESC>[1m<ESC>[4m'Underline prompt'<ESC>[m
      set pause on

      Note that the <ESC> must be a real esc, not the characters <,E,S,C and >.
Re: Data load with SQL Plus - how to see the results ? [message #245910 is a reply to message #245723] Tue, 19 June 2007 04:11 Go to previous message
michael.mazuk
Messages: 14
Registered: June 2007
Junior Member
Ok perfect ! Thank you for your help !
Previous Topic: How to upgrade customers DB
Next Topic: Workflow issue
Goto Forum:
  


Current Time: Fri Dec 09 11:33:04 CST 2016

Total time taken to generate the page: 0.11834 seconds