/*查找所需的OBJECT*/
COL OBJECT_NAME FORM A30
COL OBJECT_TYPE FORM A30
SELECT OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS
WHERE OBJECT_NAME LIKE '%&OBJECT_NAME%'
AND OBJECT_TYPE IN ('TABLE','VIEW') ;
COL OBJECT_NAME FORM A30
COL OBJECT_TYPE FORM A30
SELECT OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS
WHERE OBJECT_NAME LIKE '%&OBJECT_NAME%'
AND OBJECT_TYPE IN ('TABLE','VIEW') ;