SELECT OWNER,OBJECT_NAME AS TABLE_NAME,NAME AS COLUMN_NAMEFROM SYSCOLUMNS, (SELECT OBJECT_ID,OWNER,OBJECT_NAMEFROM DBA_OBJECTSWHERE OBJECT_TYPE = 'TABLE’AND OWNER NOT IN (‘SYSAUDITOR’,‘SYS’,‘SYSJOB’))WHERE ID = OBJECT_IDAND INFO2 = 1;
文章
阅读量
获赞