select owner 所有者, object_name 视图名称
from all_objects
where object_type='VIEW';当然,select owner 所有者, object_name 表名称
from all_objects
where object_type='TABLE';
就会返回当前用户可访问的所有表信息了;
from all_objects
where object_type='VIEW';当然,select owner 所有者, object_name 表名称
from all_objects
where object_type='TABLE';
就会返回当前用户可访问的所有表信息了;
select a.owner,a.object_name ,b.text
from all_objects a,sys.view$ b
where a.object_id=b.obj#
order by a.owner;