Oracle如何查询某临时表是否存在?
SELECT * FROM ALL_OBJECTS
WHERE OBJECT_NAME = 'XXX '
select * from user_tables where table_name =upper( 'yourtablename ')
Oracle 如何判断临时表是否存在
本文导语: Oracle如何查询某临时表是否存在? SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = 'XXX ' select * from user_tables where table_name =upper( 'yourtablename ')
Oracle如何查询某临时表是否存在?
SELECT * FROM ALL_OBJECTS
WHERE OBJECT_NAME = 'XXX '
select * from user_tables where table_name =upper( 'yourtablename ')