OraFAQ Forum: SQL & PL/SQL » accessing system variables

Home » SQL & PL/SQL » SQL & PL/SQL » accessing system variables

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

accessing system variables [message #20653]

Tue, 11 June 2002 07:35

V Sh
Messages: 8
Registered: June 2002

Junior Member

Is there anyway I can access the release number of oracle in a sql or pl/sql query?
I am just able to view the release with the following command :
SHOW REL
But I want to access it in a query.
Thanks....

Report message to a moderator

Re: accessing system variables [message #20654 is a reply to message #20653]

Tue, 11 June 2002 07:51

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator


37 rows selected.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE    9.0.1.0.0       Production
TNS for Solaris: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production

SQL>

Report message to a moderator

Previous Topic:	Re: Refreshing the Materialized view
Next Topic:	Re: accessing system variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 16:45:05 CDT 2024