Oracle Table Creation Time: How to Check

1 year ago
Emily Johnson
1 minute

To check the creation time of a table, you can use the following SQL statement:

SELECT created
FROM user_objects
WHERE object_type = 'TABLE'
AND object_name = 'your_table_name';

In this SQL statement, replace ‘your_table_name’ with the name of the table whose creation time you want to view. This statement will return the creation time of the specified table.

bannerAds