e.g.
set linesize 200
set pagesize 100
column object_name format a30
column object_type format a106 -- optional
column owner format a30 -- optional
select object_name, object_type, owner from dba_objects where status = 'INVALID' order by owner, object_type, object_name;
Note that "30" is limit of object_name and owner size. In addition,
"106" is limit of object_type size.
linesize; line limit of each row
pagesize; total row limit of display
set linesize 200
set pagesize 100
column object_name format a30
column object_type format a106 -- optional
column owner format a30 -- optional
select object_name, object_type, owner from dba_objects where status = 'INVALID' order by owner, object_type, object_name;
Note that "30" is limit of object_name and owner size. In addition,
"106" is limit of object_type size.
linesize; line limit of each row
pagesize; total row limit of display