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: 65155
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: Tips and Tricks Involved how to write a Test Script
Next Topic: Unique record in Datablock
Goto Forum:

Current Time: Thu Aug 24 00:07:28 CDT 2017

Total time taken to generate the page: 0.01835 seconds