可以用select * from all_objects where object_name = '表名',但要注意表名是区分大小写的。
查询视图select * from all_objects where ...重点关注owner object_name object_type三个字段
drop table if exists mytable;