.comment-link {margin-left:.6em;}
Marc Boizeau's blog
Friday, April 01, 2005
  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

 
Comments: Post a Comment

Links to this post:

Create a Link



<< Home
You are a developer and work with Oracle and Microsoft technologies? Have a look!
ATOM
How to:
Use updatable views in Access
Get data in Excel from Oracle 1
Get data in Excel from Oracle 2
Draw the Mandelbrot set using C#
Use the "Grouping Sets" SQl Syntax
Use the "Rollup" SQl Syntax
Use the "Rank over" SQl Syntax

link
Quotes & parameters
Oracle sequences and ADO .Net.
Back to work
Code generation and self description
links
Oracle data dictionary
Code generation with .net
Change all querytable in an Excel File
My Wiki contributions
ARCHIVES
October 2004 / November 2004 / December 2004 / January 2005 / February 2005 / March 2005 / April 2005 / June 2005 / July 2005 / August 2005 / September 2005 / December 2005 / February 2006 / December 2006 / March 2009 /


Powered by Blogger

mboizeau.free.fr