How can we check the creation time of a table in PL/SQL?

In PL/SQL, you can use the following query to view the creation time of a table:

SELECT CREATED 
FROM USER_OBJECTS 
WHERE OBJECT_NAME = 'YOUR_TABLE_NAME' AND OBJECT_TYPE = 'TABLE';

Replace YOUR_TABLE_NAME with the name of the table for which you want to see the creation time. This query will return the creation time of the table.

Leave a Reply 0

Your email address will not be published. Required fields are marked *


广告
Closing in 10 seconds
bannerAds