How to see what time which database object structure is modified

zhaozj2021-02-11  149

How to see what time which database object structure is modified

Amuber

System environment:

1, operating system: Windows 2000

2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition

3, installation path: c: / oracle

Description:

SQL> Col ​​Object_name Format A20

SQL> SELECT Object_name, - Object Name

Object_type, - Object Type

To_char (create, 'YYYY-MON-DD HH24: MI') CREATE_TIME, - creation time

To_char (last_ddl_time, 'YYYY-MON-DD HH24: MI') MOD_TIME, - Modification Time

TimeStamp, - Timestamp

STATUS - Status

From user_Objects

WHERE to_CHAR (Last_DDL_Time, 'YYYYMMDD')> '& Date Variable';

转载请注明原文地址:https://www.9cbs.com/read-5667.html

New Post(0)