http://blog.163.com/magicc_love/blog/static/185853662201210194592757/
SELECT * from v$version; or select banner from sys.v_$version; results as follows: banner 1 Oracle Database 10g Ente Rprise Edition Release 10.2.0.1.0-prod 2 PL/SQL Release 10.2.0.1.0-production 3 CORE 10.2.0.1.0 PRODUCTION&N Bsp;4 TNS for 32-bit windows:version 10.2.0.1.0-production 5 Nlsrtl Version 10.2.0.1.0-production such as: Oracle 9.0.1.1.2 9: Version number 0: New feature version number 1 (first): Maintenance version number 1 (second): Normal patch Setup number 2: Extraordinary platform patch settings number oracle version number, first look at 11g a version number description: Note: & nbsp After Oracle version 9.2, Oracle's maintenance release number is changed at the second digit bit. And before that is in the third digit digit. 1. Major Database release number The first digit, which represents a new version of the software, also marks some new features. such as 11g,10g. 2. Database Maintenance release number second digit bit, which represents a maintenance Release level, may also contain some new features. 3. Fusion Middleware Release number Third digit, which responds to the version number of Oracle Middleware (Oracle Fusion Middleware). 4. Component-specific release number fourth digit, primarily for the release level of a component. Different components have different numbers. such as Oracle's patch package. 5. Platform-specific release number Fifth digit bit, this digital bit identifies a version of the platform. Usually represents a patch number. 6. How to view version information: (1) View v$version sql> select * FROM v$version; banner ----- ----------------------------------------------------------- oracle Database 10g Enterprise Edition Release 10.2.0.4.0-prod pl/sql release 10.2.0.4.0-production core 10.2.0.4.0 & nbsp production tns for linux:version 10.2.0.4.0-production nlsrtl Version 10.2.0.4.0- production sql> (2) product_component_version view SQL> COL PRODUCT FORMAT A40 SQL> Col VERSION FORMAT a15 sql> Col STATUS FORMAT a15 sql> SELECT * from product_component_version; product & nbsp version status ------------------------------- --------------------------------------- nlsrtl &NBSP ; 10.2.0.4.0 production oracle Database 10g Enterprise Edition &N Bsp 10.2.0.4.0 prod pl/sql &NBSP ; 10.2.0.4.0 production tns for Linux: &NBSP ; 10.2.0.4.0 Production SQL> (3) dba_registry sql> select Comp_name,version,status from Dba_registry; comp_ NAME version status ------------------- ----------------------------------------- oracle Enterprise Manager 10.2.0.4.0 valid spatial  1 0.2.0.4.0 valid oracle intermedia 10.2.0.4 .0 valid olap Catalog 10.2.0 .4.0 valid oracle XML Database 10.2.0.4.0 & nbsp valid oracle Text 10.2.0.4.0 valid oracle Expression Filter 10.2.0.4.0 valid & Nbsp;oracle Rule Manager   10.2.0.4.0 valid oracle Workspace Manager & nbsp 10.2.0.4.3 valid oracle Data Mining 10.2.0.4.0 &N Bsp valid oracle Database Catalog views 10.2.0.4.0 VALID Oracle Database Packages and T 10.2.0.4.0 valid ypes jserver JAVA Virtual Machi NE 10.2.0.4.0 valid oracle XDK &NBS P 10.2.0.4.0 valid oracle Database Java Packages 10.2.0.4.0 &NBSP ; valid olap Analytic Workspace 10.2.0.4.0 valid & Nbsp;oracle OLAP API 10.2.0.4.0  VALID &NBS P Sql> &nBSP; (4) v$option view This view is based on the underlying x$option table creation, documenting the database options and features. According to different versions, such as Standard Edition, Enterprise Edition, Personal Edition. Some options require a license to be used, such as RAC,DG, partition tables, etc. SQL> Col PARAMETER format a40 sql> select * from v$option; PARAMETER  V alue ------------------------------------------------------------------------------- Partitioning true & Nbsp;objects &NBS P true real application Clusters FALSE Advanced replication true bit-mapped Inde Xes &NBSp true connection multiplexing &NBSP ; true connection pooling &NBS P True database queuing &NBSP ; True incremental Backup and recovery TRUE instead-of triggers true parallel b Ackup and recovery True parallel execution &NBSP ; True parallel load & nbsp true point-in-time tablespace recovery &NB Sp True &nBsp Fine-grained access control true proxy authentication/ Authorization True change Data Capture &N Bsp true plan stability & nbsp True online Index Build &NB Sp True coalesce Index True managed Standby true materialized View rewrite TRUE Materialized view warehouse Refresh true database resource manager &NB Sp   true spatial / nbsp true visual Information retrieval TRUE &NBS P Export Transportable tablespaces true transparent application Failover &NBS P True fast-start Fault Recovery true & nbsp Sample Scan  TRUE&N Bsp; duplexed backups true & nbsp Java &NBSP ; True olap Window Functions  TRUE&NBS P; block Media Recovery True fine-gra ined Auditing true application Role true enterprise User Security &NB Sp true oracle Data Guard &NBS P true oracle Label Security & nbsp  FALSE  OLAP &NB Sp true table compression &NBS P true join index &NBSP ; &nBsp true trial Recovery True data Mining &NB Sp true online redefinition &NB Sp true streams Capture true file Mapping &NB Sp True block change Tracking true flashback Table true flashback Database &NBS P TRUE data Mining scoring Engine False transparent Data Encryption true backup encryption & nbsp true unused Block Compression &NBSP ; true oracle Database Vault false real Application Testing True s Ql>