Oracle 如何判断临时表是否存在

SELECT * FROM ALL_OBJECTS

WHERE OBJECT_NAME = 'XXX '

select * from user_tables where table_name =upper( 'yourtablename ')