Two ways to find the version of Oracle Database:-
1. V$VERSION:-
displays version number with database edition.
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:-
No comments :
Write comments