Time lower text function : Timing « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. Timing

Time lower text function

   
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>

   
    
  

Related examples in the same category