select banner from v$version : version « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. version

select banner from v$version

 
SQL>
SQL>
SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL>

 

Related examples in the same category