日期:2014-05-17  浏览次数:20779 次

怎样判断某个对象为表
RT,求助

------解决方案--------------------
select object_name,object_type from dba_objects where object_name= 'yourobject ';
------解决方案--------------------
select object_name,object_type from user_objects where object_name= 'yourobject ';
------解决方案--------------------
如果以normal用户登录模式没有访问dba_objects权限的话,可以用
select object_type from user_objects where object_name= 'myobject ';