Home » SQL & PL/SQL » Client Tools » ECHO ON/OFF
ECHO ON/OFF [message #444273] Sat, 20 February 2010 00:07 Go to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
hi to all
i want to know that what this command will do in our database.
set echo on/off.



Thanks
Dhinendra
Re: ECHO ON/OFF [message #444274 is a reply to message #444273] Sat, 20 February 2010 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>i want to know that what this command will do in our database.
>set echo on/off.

NOTHING!
Re: ECHO ON/OFF [message #444275 is a reply to message #444273] Sat, 20 February 2010 00:14 Go to previous messageGo to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
means i want to know that what is echo in oracle database???



Thanks
Dhinendra
Re: ECHO ON/OFF [message #444276 is a reply to message #444275] Sat, 20 February 2010 00:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NOTHING!

Regards
Michel
Re: ECHO ON/OFF [message #444287 is a reply to message #444273] Sat, 20 February 2010 03:17 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
set echo on | off
With echo it is possible to control if echoing of SQL statements and SQL*Plus commands is enabled or not. If echo is set to off, SQL statements that are run will not be displayed while setting echo to on will display them.

http://download.oracle.com/docs/cd/B14117_01/server.101/b12170/ch13.htm#i2698923

sriram Smile
Re: ECHO ON/OFF [message #444499 is a reply to message #444287] Mon, 22 February 2010 05:04 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
@BlackSwan and @Michel are correct, if a little pedantic.

The SET ECHO command will do nothing at all to your database, as its only effect to on how SQL*Plus displays data, and SQL*Plus is a client program, not part of the database.
Re: ECHO ON/OFF [message #444503 is a reply to message #444499] Mon, 22 February 2010 05:08 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I agree..But i am sure that OP intention is to know what is echo on/off in oracle ..

Quote:
means i want to know that what is echo in oracle database???


sriram Smile
Previous Topic: Error in connection (Erwin 7.1.0)
Next Topic: Sql Plus and unicode.
Goto Forum:
  


Current Time: Sat Dec 03 19:56:43 CST 2016

Total time taken to generate the page: 0.09942 seconds