skip to main | skip to sidebar

Oracle Tips-n-Tricks

A helpful list of useful Oracle SQL functions.

Tuesday, April 15, 2008

Find Oracle Server Version information using SQL

To find the version of the Oracle server using SQL:
SELECT * FROM v$version WHERE banner LIKE 'Oracle%';
Posted by scspieker at 10:10 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2008 (13)
    • ▼  April (13)
      • Run SQL commands at login with SQL*Plus
      • Enabling SQL*Plus Help Utility
      • Using the default editor (Notepad or VI) for SQL C...
      • What are the basic SQL*Plus commands?
      • Shrink Oracle LOB columns
      • Display all TABLE Owning users with an Oracle SID
      • Find the Characterset Encoding for an Oracle SID
      • Display Oracle SID name using SQL
      • List existing user accounts within an Oracle SID
      • Find Oracle Server Version information using SQL
      • Unlock an Oracle user account
      • Sample Oracle Create User SQL Script
      • Oracle Create Tablespace Example