OraFAQ Forum: Forms » Changing connection in SQL*Plus

Home » Developer & Programmer » Forms » Changing connection in SQL*Plus

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

Changing connection in SQL*Plus [message #80218]

Mon, 26 August 2002 03:29

Andoni OConchubhair
Messages: 2
Registered: August 2002

Junior Member

Hello,

Two questions on the same theme:
<ol>[*]When I'm in SQL*Plus connected to one db and type
SQL>connect system/manager@mydatabase
does this change my current connection or just create a new 2nd connection? I.e. do I have to be careful to close out of both connections now?

[*]Is there a command I can type in SQL*Plus to check which of my databases/tnsnames.ora entries, I'm currently connected to?
</ol>

Thanks in Advance,

Report message to a moderator

Re: Changing connection in SQL*Plus [message #80323 is a reply to message #80218]

Mon, 09 September 2002 08:24

Sameer
Messages: 60
Registered: March 1998

Member

select name from v$database;

Report message to a moderator

Previous Topic:	come to my rescue
Next Topic:	Forms/Reports Source Code Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:49:02 CDT 2024