Home » SQL & PL/SQL » SQL & PL/SQL » Is function return null value? (9.0.4.0)
Is function return null value? [message #318196] Tue, 06 May 2008 01:39 Go to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: Is function return null value? [message #318200 is a reply to message #318196] Tue, 06 May 2008 01:46 Go to previous messageGo to next message
pablolee
Messages: 2836
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.
Re: Is function return null value? [message #318201 is a reply to message #318199] Tue, 06 May 2008 01:47 Go to previous messageGo to next message
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
Re: Is function return null value? [message #318203 is a reply to message #318201] Tue, 06 May 2008 01:50 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Then as Frank says, try it for yourself.
Re: Is function return null value? [message #318204 is a reply to message #318201] Tue, 06 May 2008 02:00 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Can function return a null value" and "function must return a value" are 2 different things.

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


Current Time: Sun Dec 11 00:06:53 CST 2016

Total time taken to generate the page: 0.07524 seconds