BUILT-IN FUNCTIONS VIEWABLE THROUGH SQL*PLUS!POSSIBLE!

Hi all!

Working on Oracle v8i 8.1.6.0.0 with OS as NT!

Query:

1.How could we view the BUILT-IN FUNCTIONS of Oracle through sql*plus!is this possible!

Thanks & Regards,

Amit.

I'm not quite sure what do you mean by "Can I view the BUILT-IN FUNCTIONS of Oracle through sql*plus?", but if you mean "can I list the built-in functions through SQL*Plus?" then sure, every user that can log into SQL*Plus can list them, together with the arguments they require and the datatype they return. Simply isue:

DESCRIBE SYS.STANDARD

And be prepared to a very long listing!

You can view functions, (as well as packages, procedures and triggers) with DBAStudio.

Good luck