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: 64103
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: Row value as column name
Next Topic: ORA-00604,ORA-00904 error
Goto Forum:
  


Current Time: Sat Dec 03 16:29:27 CST 2016

Total time taken to generate the page: 0.07980 seconds