Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

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

 
Thread Tools Display Modes
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: 269
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
 
     


Thread Tools
Display Modes

 
Similar Sponsors

Similar Threads
Question Asker Forum Answers Last Post
creation of 0V neutral misanthrope Electrical & Lighting 4 Nov 5, 2007 05:15 PM
Self-referenced table in Oracle 9i database for huge amounts of data VladimirD Oracle 5 Mar 27, 2007 07:05 PM
Creation science RickJ Humor & Comedy 13 Feb 27, 2007 07:57 AM
new user creation muthusamy777 Desktops 3 Dec 6, 2006 06:18 AM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 02:24 PM.