OraFAQ Forum: SQL & PL/SQL » What are function we can't use in PL/SQL

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)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

What are function we can't use in PL/SQL [message #350608]

Thu, 25 September 2008 10:35

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Tips and Tricks Involved how to write a Test Script
Next Topic:	Unique record in Datablock

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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

Total time taken to generate the page: 0.01835 seconds