OraFAQ Forum: SQL & PL/SQL » Is function return null value?

Home » SQL & PL/SQL » SQL & PL/SQL » Is function return null value? (9.0.4.0)

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

Is function return null value? [message #318196]

Tue, 06 May 2008 01:39

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hi All,

Is FUNCTION return null value? Please give me example for this.

and one more " How to calculate database size?

Please give me answers for this..

Thank you.

[Updated on: Tue, 06 May 2008 01:40]

Report message to a moderator

Re: Is function return null value? [message #318199 is a reply to message #318196]

Tue, 06 May 2008 01:45

Frank
Messages: 7901
Registered: March 2000

Senior Member

"Is function return null value"
What do you mean? Can a function return a null value? Try it. See what happens.

Report message to a moderator

Re: Is function return null value? [message #318200 is a reply to message #318196]

Tue, 06 May 2008 01:46

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Are you EVER going to 'get' how this place works? I doubt it. *sigh* I pity the company that is eventually fooled into taking you on.

Report message to a moderator

Re: Is function return null value? [message #318201 is a reply to message #318199]

Tue, 06 May 2008 01:47

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

according to me "Function must returns a value".
Recently I faced this question in an interview.. That's why I want to clarify my doubt...

Thank you

Report message to a moderator

Re: Is function return null value? [message #318203 is a reply to message #318201]

Tue, 06 May 2008 01:50

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Then as Frank says, try it for yourself.

Report message to a moderator

Re: Is function return null value? [message #318204 is a reply to message #318201]

Tue, 06 May 2008 02:00

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"Can function return a null value" and "function must return a value" are 2 different things.

Regards
Michel

Report message to a moderator

Previous Topic:	How to create an autonomous tranaction to solve the mutation error
Next Topic:	Challenging task !!!(query help)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 13:01:46 CDT 2025