Ask Experts Questions for FREE Help!
Answer   ||    Advanced Search    ||    Help
Ask your question or search...
Login with Facebook
User Name 
Password 
Forgot password? 

Want to become a member? It's free and once you join you can ask and answer questions. Join Now!

Home > Computers & Technology > Programming > Databases > Oracle   »   creation day of oracle database

Question
 
 
#1  
Old Jul 28, 2007, 09:19 AM
sghandch
New Member
sghandch is offline
 
Join Date: Jul 2007
Posts: 1
sghandch See this member's comment history on his/her Profile page.
creation day of oracle database

How to find out when Oracle database was created by writing a sql?

Thank you
Sam

Reply With Quote
 
     

Answers
 
 
Old Oct 5, 2007, 02:18 PM   #2  
Full Member
DaBaAd is offline
 
DaBaAd's Avatar
 
Join Date: Oct 2007
Location: Tex
Posts: 273
DaBaAd See this member's comment history on his/her Profile page.
Quote:
Originally Posted by sghandch
How to find out when Oracle database was created by writing a sql?

Thank you
Sam
Sign into Oracle as sys or system.

Issue the following SQL:

SQL> select created from v$database;


You should see something like:

CREATED
---------
26-FEB-07

Hope this helps.
  Reply With Quote
 
     

Answer this question

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Ask your question or search...

 




Similar Threads
creation of 0V neutral
(4 replies)
Self-referenced table in Oracle 9i database for huge amounts of data
(5 replies)
Creation science
(13 replies)
new user creation
(3 replies)


Bookmarks and Sharing
bookmark twitter facebook

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Search this Thread

Advanced Search




Copyright ©2003 - 2010 - Advizo, LLC
All times are GMT -8. The time now is 10:28 PM.