Home » SQL & PL/SQL » SQL & PL/SQL » Re: SID ?
Re: SID ? [message #3020] Fri, 30 August 2002 05:10
Manju
Messages: 10
Registered: November 2000
Junior Member
Hi,

If you are trying to find the sid name from your sql plus session, try this

select global_name from global_name ;

Alternately , you could use
SELECT NAME FROM V$DATABASE ;

Hope this helps

Cheers,
Manju

Report message to a moderator

Previous Topic: Creating a text file in PL/SQL ( Urgent !!!!!!!!!!!!!)
Next Topic: Re: want to stop the insert/delete/update transaction in an AFTER TRIGGER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 00:07:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.