Home » SQL & PL/SQL » SQL & PL/SQL » What are function we can't use in PL/SQL (Oracle9i Enterprise Edition Release - Production)
What are function we can't use in PL/SQL [message #350608] Thu, 25 September 2008 10:35 Go to next message
Messages: 96
Registered: April 2007
Location: Chennai

Hi All,

Good day,
I would like to know, what are the build in function we can not use in PL/SQL black whereas we can use those in SQL.

I know only one. 


Can you please tell me, is there any other functions.

Thanks & Regards
Re: What are function we can't use in PL/SQL [message #350614 is a reply to message #350608] Thu, 25 September 2008 10:46 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nextval and currval sequence functions (before 11g).
Grouping and analytic functions.

But what about checking yourself all SQL functions and tell us the answer?

Previous Topic: Row value as column name
Next Topic: ORA-00604,ORA-00904 error
Goto Forum:

Current Time: Fri Oct 21 21:44:44 CDT 2016

Total time taken to generate the page: 0.10346 seconds