Home » SQL & PL/SQL » SQL & PL/SQL » Reg-version
Reg-version [message #18506] Sat, 02 February 2002 02:14 Go to next message
Nantha
Messages: 4
Registered: December 2001
Junior Member
Hai all,

How can I know the oracle version from sql stmt.

we have two tables like sm$version and v$version what is the difference between these tables .

Please give me the answer.

Thanks in advance

With Love ,

Nantha.

Report message to a moderator

Re: Reg-version [message #18509 is a reply to message #18506] Sat, 02 February 2002 05:46 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select banner from v$version

Report message to a moderator

Previous Topic: Re: How do I convert the difference between two dates into a date format
Next Topic: Very urgent date problem in oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 01:25:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.