Srs Good morning ..
Is there a way to pull in SQL the date of creating a table?
Thanks for the support.
Date of creation of table in SQL
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Yes.
You can use this query:
Query return:
: -O
You can use this query:
select OWNER, OBJECT_NAME, OBJECT_TYPE, CREATED, LAST_DDL_TIME
from all_objects
where object_name='CONTRACTS'
OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_TIME
---------------------- ---------------------- ------------------- ----------- -------------
ASSET CONTRACTS TABLE 10/29/2015 10/4/2016 2:3
SQL>
-
- Rank: Estagiário Pleno
- Posts: 3
- Joined: Tue, 10 Jan 2017 9:04 am
Guys I only have to thank you ... Thank you very much.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 33 guests