Working on Oracle v8i 220.127.116.11.0 with OS as NT!
1.How could we view the BUILT-IN FUNCTIONS of Oracle through sql*plus!is this possible!
Thanks & Regards,
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:
And be prepared to a very long listing!
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
You can view functions, (as well as packages, procedures and triggers) with DBAStudio.
OCP DBA 8i, 9i, 10g
Click Here to Expand Forum to Full Width