SQL>
SQL> create table my_all_objects
2 nologging
3 as
4 select * from all_objects
5 union all
6 select * from all_objects
7 union all
8 select * from all_objects
9 /
Table created.
SQL>
SQL>
SQL> spool off
not spooling currently
SQL> set termout on
SQL>
SQL>
SQL> set timing on
SQL> select lower(owner) from my_all_objects group by owner;
LOWER(OWNER)
------------------------------
mdsys
tsmsys
flows_020100
public
outln
java2s
ctxsys
hr
flows_files
system
dbsnmp
LOWER(OWNER)
------------------------------
xdb
sys
13 rows selected.
Elapsed: 00:00:00.25
SQL> set timing off
SQL>
SQL> drop table my_all_objects;
Table dropped.
SQL>
SQL>
SQL>
|