OraFAQ Forum: Client Tools » Difference between EXIT and DISCONN

Home » Other » Client Tools » Difference between EXIT and DISCONN

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

Difference between EXIT and DISCONN [message #246434]

Wed, 20 June 2007 23:37

srinivasocp
Messages: 91
Registered: December 2005
Location: INDIA

Member

Hi Pals,

Could you please tell me the difference between EXIT and Disconn.

Firstly i have defined a variable with the DEFINE Keyword in a schema(say Scott).

SQL> define myv='XYZ';
SQL> define myv;
DEFINE MYV = "XYZ" (CHAR)

Just disconn from the schema(SCOTT).I am able to see the value of the defined variable 'myv' even after disconnecting from the shema

SQL> show user
USER is ""

Then again i connected to another schema(say HR).Here also the value of defined variable is persisting.

SQL> show user
USER is "HR"

SQL> define myv;
DEFINE MYV = "XYZ" (CHAR).

Now i typed exit and logged in again as SCOTT,but this time i am unable to see the value of defined variable myv.

My question is why after disconnecting,the value of a defined variable is existing?Doesn't disconnect mean end of the session?

Please clarify.

Thanks
Srini..

Report message to a moderator

Re: Difference between EXIT and DISCONN [message #246459 is a reply to message #246434]

Thu, 21 June 2007 01:04

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

Senior Member
Account Moderator

"disconnect" disconnects from Oracle but you still stay in the application (SQL*Plus) and so keep your application environment.
"exit" quits the application and so you lose your application environment.

Variables declared with "define" are SQL*Plus variables.

Regards
Michel

Report message to a moderator