Show LiveSQL Version

View All Scripts Login to Run Script

Script Name Show LiveSQL Version
Description Run this script to see the version of the Oracle Database on which LiveSQL is running (and your own instance if you run this script there).
Area SQL General
Contributor Steven Feuerstein
Created Monday November 16, 2015

Statement 1

select * from PRODUCT_COMPONENT_VERSION

 
PRODUCT VERSION STATUS
NLSRTL 12.1.0.2.0 Production
Oracle Database 12c Enterprise Edition 12.1.0.2.0 64bit Production
PL/SQL 12.1.0.2.0 Production
TNS for Linux: 12.1.0.2.0 Production

4 rows selected.

PRODUCT	VERSION	STATUS
NLSRTL	12.1.0.2.0	Production
Oracle Database 12c Enterprise Edition	12.1.0.2.0	64bit Production
PL/SQL	12.1.0.2.0	Production
TNS for Linux:	12.1.0.2.0	Production

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database