Which Oracle version is running?

Two ways to find the version of Oracle Database:-
1. V$VERSION:-
displays version number with database edition.

select * from v$version;

2. PRODUCT_COMPONENT_VERSION:-displays version and status information for component products with database edition.

set lines 200 
column product format a50
column version format a15
column status format a20
select * from product_component_version ;

Below is the output of given SQL Scripts:-

Similar Questions:-

What is the Edition of Oracle database ?

No comments :
Write comments