oracle functions Today just a little Oracle trick: the all_arguments view.

On your favourite Oracle Client try this :

select distinct package_name from all_arguments

this will list every packages including yours on the current schema.

then try this one:


select distinct object_name
from all_arguments where package_name like 'STANDARD'


this will list every standard functions installed. I've found it useful when try to remember the exact syntax of "NUMTODSINTERVAL " or "NUMTOYMINTERVAL".


that's all folks

hope this helps

comments are welcome

  ¶ 6:38 AM