Collections:
Show the Server Version in Oracle
How To Check the Server Version in Oracle?
✍: FYIcenter.com
Oracle server version information is stored in a table called: PRODUCT_COMPONENT_VERSION. You can use a simple SELECT statement to view the version information like this:
>.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SYSDBA Connected to an idle instance SQL> COL PRODUCT FORMAT A35 SQL> COL VERSION FORMAT A15 SQL> COL STATUS FORMAT A15 SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCT VERSION STATUS ----------------------------------- ----------- ---------- NLSRTL 10.2.0.1.0 Production Oracle Database 10g Express Edition 10.2.0.1.0 Product PL/SQL 10.2.0.1.0 Production TNS for 32-bit Windows: 10.2.0.1.0 Production
⇒ Introduction to Command-Line SQL*Plus Client Tool
⇐ Change Settings in Binary SPFile in Oracle
2020-09-15, 3651🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...