oracle建表日期 如何查詢oracle表的創(chuàng)建日期?
如何查詢oracle表的創(chuàng)建日期?1 SELECT*FROM ALL uobjects WHERE OBJECT NAME=“OBJNAME”2 SELECT OWNER,OBJECT NAME,CR
如何查詢oracle表的創(chuàng)建日期?
1 SELECT*FROM ALL uobjects WHERE OBJECT NAME=“OBJNAME”2 SELECT OWNER,OBJECT NAME,CREATED FROM dba OBJECTS WHERE OBJECT NAME=“table NAME”CREATED是表的創(chuàng)建時(shí)間。OBJECTS表需要dba權(quán)限