Oracle查看数据库中表的创建时间
create table test(id int);select created,last_ddl_time from user_objects where object_name = 'TEST';
·
create table test(id int);
select created,last_ddl_time from user_objects where object_name = 'TEST';
select to_char(created, 'HH24:MI:SS') "Created" , to_char(last_ddl_time, 'HH24:MI:SS') "DDL" from user_objects where object_name = 'TEST';
更多推荐
已为社区贡献55条内容
所有评论(0)