OraFAQ Forum: Client Tools

Home » Other » Client Tools » ECHO ON/OFF

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

ECHO ON/OFF [message #444273]

Sat, 20 February 2010 00:07

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

Report message to a moderator

Re: ECHO ON/OFF [message #444274 is a reply to message #444273]

Sat, 20 February 2010 00:09

BlackSwan
Messages: 26766
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!

Report message to a moderator

Re: ECHO ON/OFF [message #444275 is a reply to message #444273]

Sat, 20 February 2010 00:14

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

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

Thanks
Dhinendra

Report message to a moderator

Re: ECHO ON/OFF [message #444276 is a reply to message #444275]

Sat, 20 February 2010 00:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

NOTHING!

Regards
Michel

Report message to a moderator

Re: ECHO ON/OFF [message #444287 is a reply to message #444273]

Sat, 20 February 2010 03:17

ramoradba
Messages: 2457
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

Report message to a moderator

Re: ECHO ON/OFF [message #444499 is a reply to message #444287]

Mon, 22 February 2010 05:04

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.

Report message to a moderator

Re: ECHO ON/OFF [message #444503 is a reply to message #444499]

Mon, 22 February 2010 05:08

ramoradba
Messages: 2457
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:07:12 CST 2024