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

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. 

DECODE.

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




Thanks & Regards
Thangam
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.
NVL2

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

Regards
Michel
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