Express a number as a percentage

TO_CHAR(bcl.tax_rate, '90.99L','NLS_CURRENCY=''%''' )

Output = 10.01% or 99.99% or 0.00%

Cacheing the result of function

http://www.oracle-developer.net/display.php?id=504

LISTAGG

http://www.oracle-developer.net/display.php?id=515


Pivots rows into comma separated list

Linux Command stack search

esc-p or !command or !?command

eg.
!ls
!?ls
esc-p followed by ls

DBMS_MVIEW.REFRESH - atomic_refresh

One of the thing that is not well documented about setting atomic_refresh => false
is it cause the refresh to truncate rather than delete from the Mview. The result can be a much quicker refresh.

How to change properties/attributes of partition table?

ALTER TABLE scott.part_table MODIFY DEFAULT ATTRIBUTES TABLESPACE NEW_TABLESPACE;

ALTER INDEX scott.local_index MODIFY DEFAULT ATTRIBUTES TABLESPACE NEW_TABLESPACE_IDX;

ACL lists

All you need to know is  here

http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_networkacl_adm.htm