【Oracle字典表应用】利用字典表查表是否存在

【Oracle SQL】

一行流方式：

select count(*) from all_tables where table_name=upper('your tableName')

层次化方式：

select count(*) 
from all_tables 
where table_name=upper('your tableName')

 

【PG SQL】

一行流方式：

select count(*) from information_schema.table where table_schema='your schema' and table_type='BASE TABLE' and upper(table_name)=upper('your tableName')

层次化方式：

select count(*) 
from information_schema.table 
where 
table_schema='your schema' and 
table_type='BASE TABLE' and 
upper(table_name)=upper('your tableName')

END