Home » SQL & PL/SQL » SQL & PL/SQL » Is correct function..
Is correct function.. [message #239666] Wed, 23 May 2007 00:41 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

can u tell me

which things are correct:

1) function call other function cannot contain DML.
2) function cannot call other subpgm.
3)function contain DML cannot call sql stmt.


Expecting your replies..

Arun..
Re: Is correct function.. [message #239668 is a reply to message #239666] Wed, 23 May 2007 00:45 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
1) no
2) no
3) no
Re: Is correct function.. [message #239669 is a reply to message #239666] Wed, 23 May 2007 00:48 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear anacent,

Can u tell me why?please..

Arun..
Re: Is correct function.. [message #239680 is a reply to message #239669] Wed, 23 May 2007 01:15 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
closed.

http://www.orafaq.com/forum/fa/448/0/

MHE

Edit: Some clarifications.

Arun,
before you get the impression that I'm after you allow me to explain. At OraFAQ, we have adopted some simple guidelines. We have pointed you to them on multiple occasions. I also have tried to help you personnaly throught private messaging. Not only do you ignore those messages, you also ignore advice from every single member here.

Your questions can be easily answered by testing yourself. You can download - for free! - a working Oracle database, Oracle XE (Express Edition). I use it myself to test things. The download size is about 200 megabytes. Once you've set up your database, just click 'start database' and start testing.

Pfew. And now: read that sticky!

[Updated on: Wed, 23 May 2007 01:26]

Report message to a moderator

Previous Topic: Functions..
Next Topic: Regarding bulk update
Goto Forum:
  


Current Time: Sun Dec 11 04:12:11 CST 2016

Total time taken to generate the page: 0.15959 seconds