oracle:查询数据表是否存在

oracle:查询数据表是否存在

select count(*) as NUM from all_tables where table_name = '{$table}'

  

或者:

select count(*) as NUM from all_tables where owner = '{$user}' and table_name = '{$table}'
某个用户是否拥有这张表

  

posted @ 2017-03-23 14:21  穆晟铭  阅读(2504)  评论(0编辑  收藏  举报