批量检索指定表的类型
create table temp_countdate (counts int,tname varchar2(40),tcolumn varchar2(40)) ;
--SELECT *FROM TEMP_COUNTDATE WHERE COUNTS >0
--DROP TABLE TEMP_COUNTDATE ;
SELECT
'INSERT INTO temp_countdate (COUNTS,TNAME,TCOLUMN ) ' ||
'SELECT count(*),' ||
''''||
u.Table_Name || '''' || ' ,' ||
''''||
u.column_name || '''' ||
' from ' || u.Table_Name || ' where ' || u.column_name ||
'< TO_DATE( ' || '''' || '1900-01-01 00:00:00' || '''' || ',' || '''' ||'yyyy-mm-dd hh24:mi:ss' ||
'''' || ' ) ;' FROM User_Tab_Cols u
inner join user_tables t on u.table_name = t.table_name
WHERE T.TABLESPACE_NAME IS NOT NULL
AND U.DATA_TYPE = 'DATE'
AND T.TABLESPACE_NAME <> 'TABLE_SSISTMP'
AND U.COLUMN_NAME<>'UPDATETIMESTAMP'
ORDER BY U.TABLE_NAME ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/17066567/viewspace-671901/ ，如需转载，请注明出处，否则将追究法律责任。
