Query to find database version in oracle
Because Oracle Database continues to evolve and can require maintenance, Oracle periodically produces new releases. Not all customers initially subscribe to a new release or require specific maintenance for their existing release. As a result, multiple releases of the product exist simultaneously.
As many as five numbers may be required to fully identify a release. The significance of these numbers is discussed in the sections that follow.
Major Database Release Number
The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.
Database Maintenance Release Number
The second digit represents a maintenance release level. Some new features may also be included.
Application Server Release Number
The third digit reflects the release level of the Oracle Application Server (OracleAS).
Component-Specific Release Number
The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.
Platform-Specific Release Number
The fifth digit identifies a platform-specific release. Usually this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.
Checking Your Current Release Number
To identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary view PRODUCT_COMPONENT_VERSION. A sample query follows. (You can also query the V$VERSION view to see component-level information.) Other product release levels may increment independent of the database server.
COL PRODUCT FORMAT A35 COL VERSION FORMAT A15 COL STATUS FORMAT A15 SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCT VERSION STATUS - - - NLSRTL 10.2.0.1.0 Production Oracle Database 10g Enterprise Edition 10.2.0.1.0 Prod PL/SQL 10.2.0.1.0 Production ...success antonym success auto sales success baby success clipart success doesn't come from what you do occasionally success image success images success in life success inspirational quotes for work success is counted sweetest success mindset success motivational quotes for work success overnight success positive affirmations success positive motivational quotes success quotes success quotes for men success realty success sharing home depot success sharing home depot success synonyms success thesaurus success through a positive mental attitude success wallpaper success words technaflora recipe for success tethered spinal cord surgery success rate the key success factors in an industry the key to success tarkov the national society of leadership and success reviews the seven spiritual laws of success there is no elevator to success tools for success was reconstruction a success what does a customer success manager do what is the success rate of a spinal cord stimulator attitude eagle quotes success bumble success stories dress for success denver foster care to success how do you spell success lake success, ny membrane sweep success rate misdiagnosed blighted ovum success stories opposite of success performance manager 4 success factors provera pregnancy success success good luck wishes success hunters success in latin success is no accident quotes the law of success celebrate success continuing success goal success quotes ivf success key to success in life magnet of success married at first sight success rate quotes about failure and success slug success success affirmations success credit union success interviews success quotes for business success rate of iui vitrectomy success rate what does a customer success manager do amazon onsite interview success rate ivf calculator success keto success motivate for success ralph waldo emmerson success stem cell transplant success rate study to success success books success companies success is not final, failure is not fatal: it is the courage to continue that counts. success mantra success pronunciation success quote success vision paducah ky the law of success weight watchers success stories achieves success animal mating success ankle ligament surgery success rate attitude eagle quotes success borat great success castor oil at 37 weeks success cdc ivf success rates center for academic success cerebral success class room for success crystal for success customer success metrics director of customer success salary dress for success locations near me equipped for reading success failure and success quotes geritol pregnancy success stories 2020 hotel dash suite success how do you define success interview question how i raised myself from failure to success in selling isaac success iui success stories 2020 ivf success rates by age 2020 ivf success stories john wooden success quote key to success lake success, new york late ovulation pregnancy success liver transplant success rate lumbar radiofrequency ablation success rate mantras for success march to success metformin weight loss success stories mindset the new psychology of success motivational quotes for students success motivational quotes for work success motivational speeches for success outliers the story of success p shot success rate pearson success net peloton success stories pillars of success positive quotes about success prayer for exam success prayer for success at work quotes for future success quotes success rowing machine weight loss success stories rowing machine weight loss success stories scentsy success secret to my success seven spiritual laws of success pdf skill success skill success success success academy middle schools success criterias success factor success meanings success motivation success nutrition facts success plan template success quotes for work success rice success rice out of the bag success thesaurus success vision express success vision topeka success vision topeka sweet success cucumber the 10x rule: the only difference between success and failure the 7 spiritual laws of success the secret of my success the secrets of lake success tips for success topamax and phentermine weight loss success stories 2020 tti success insights vaccine success vasectomy success rate weaning off cymbalta success stories what is success to you framing success plan for success student success center gcu student success completion grant success companies success driving school success is a journey not a destination