| shipon |
Posted: May 14, 2008 07:30:58 AM |
Total Post: 27
Joined: Feb, 2008
|
Dear Friends,
I want to know which oracle version i use ?
Is it possible to find out the oracle version from SQL prompt ? |
|
|
 GOPU |
| Posted: May 14, 2008 07:49:50 AM |  |
|
Total Post: 242
Joined: Apr, 2008
|
use this query..
select * from v$version;
|
|
|
|
|
| Gitesh |
| Posted: May 14, 2008 07:53:04 AM | |
|
Total Post: 322
Joined: May, 2005
|
When you start SQL plus at that time you get version of oracle.
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 05:48:32 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
some more commands to check DB version
select * from PRODUCT_COMPONENT_VERSION;
SET SERVEROUT ON
EXEC DBMS_OUTPUT.PUT_LINE (DBMS_DB_VERSION.VERSION);
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
