All Oracle documentation is available online at tahiti.oracle.com.
ECHO {ON|OFF} Controls whether the START command lists each command in a command file as the command is executed. ON lists the commands; OFF suppresses the listing.
********************************************
Abhay,
It appears to be immaterial.But I am sure it matters ..
Let st2000 try it and we will see if it works.
Before posting my first reply I tested it and only then I posted ..
But one thing to be noted ,by initial setting when I logged into sql+
echo setting was OFF and so it didnot record select st in spool file.
After that I set it to ON .I could see the select st in spool file.
again when I reset it to OFF ,but still I could see the select st in spool file.
This happens till I relogon into SQL+ and repeat the same.
I checked in metalink ,It gave some what relevant matter:
"In order for the SET ECHO OFF command to be effective it must be issued from a SQL*Plus command file that is called using the SQLPLUS START command.....any previous SET ECHO OFF commands are not effective. ".
We have to wait till st2000 tries it .
If it doesnot work ,I will accept it is immaterial.
Originally posted by k.chithra All Oracle documentation is available online at tahiti.oracle.com.
ECHO {ON|OFF} Controls whether the START command lists each command in a command file as the command is executed. ON lists the commands; OFF suppresses the listing.
********************************************
Abhay,
It appears to be immaterial.But I am sure it matters ..
Let st2000 try it and we will see if it works.
Before posting my first reply I tested it and only then I posted ..
But one thing to be noted ,by initial setting when I logged into sql+
echo setting was OFF and so it didnot record select st in spool file.
After that I set it to ON .I could see the select st in spool file.
again when I reset it to OFF ,but still I could see the select st in spool file.
This happens till I relogon into SQL+ and repeat the same.
I checked in metalink ,It gave some what relevant matter:
"In order for the SET ECHO OFF command to be effective it must be issued from a SQL*Plus command file that is called using the SQLPLUS START command.....any previous SET ECHO OFF commands are not effective. ".
We have to wait till st2000 tries it .
If it doesnot work ,I will accept it is immaterial.
Cheers!!
Hi chithra
Code:
17:45:19 SQL> set trimspool on
17:47:33 SQL> set echo off
17:47:37 SQL> show echo
echo OFF
17:47:40 SQL> spool c:\dba\test.txt
17:47:43 SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- --------------------
DIEDB VIEW
TEST TABLE
TEST1 TABLE
3 rows selected.
17:47:46 SQL> spool off
Check out the spool file contents for urself if SQL staements are suppressed.......
Defualt Echo is off and if u spool, u do get SQL.......Even on relogon the result being same........
S in DOS batch scripts it does effect.........
Abhay.
Last edited by abhaysk; 03-02-2003 at 08:27 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
1.logon (close sql+ and relogon fresh)
2.sho echo
3.Let me know if it is ON or OFF.
DON'T SET IT OFF explicitly.
I suspect it should be ON for u
Whereas when I logged in it was OFF..
The reason is it is taking value from a file 'login.sql' where default settings are given .It is having the first precedence.
Can u pls check ur login.sql and check the default value given..
Eagerly waiting for ur reply..
Originally posted by k.chithra Hai Abhay,
Can u pls do the foll and check
1.logon (close sql+ and relogon fresh)
2.sho echo
3.Let me know if it is ON or OFF.
DON'T SET IT OFF explicitly.
I suspect it should be ON for u
Whereas when I logged in it was OFF..
The reason is it is taking value from a file 'login.sql' where default settings are given .It is having the first precedence.
Can u pls check ur login.sql and check the default value given..
Eagerly waiting for ur reply..
Cheers
SQL*Plus: Release 9.0.1.0.1 - Production on Sun Mar 2 18:34:38 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter password: *****
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
SQL> show echo
echo OFF
SQL>
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"