Home » Other » Training & Certification » To be callable from a SQL expression, a user-defined funcation must do what?
To be callable from a SQL expression, a user-defined funcation must do what? [message #360749] Sun, 23 November 2008 21:24 Go to next message
registereduser
Messages: 52
Registered: June 2008
Location: Toronto
Member
A. Be stored only in the database.
B. Have both IN and OUT parameters.
C. Use the positional notation for parameters.
D. Return a BOOLEAN or VARCHAR2 data type.

And why?
Re: To be callable from a SQL expression, a user-defined funcation must do what? [message #360801 is a reply to message #360749] Mon, 24 November 2008 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your opinion and why?
What did you already search by yourself?

Regards
Michel
Re: To be callable from a SQL expression, a user-defined funcation must do what? [message #360840 is a reply to message #360749] Mon, 24 November 2008 02:13 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
registereduser wrote on Mon, 24 November 2008 04:24
A. Be stored only in the database.
B. Have both IN and OUT parameters.
C. Use the positional notation for parameters.
D. Return a BOOLEAN or VARCHAR2 data type.

And why?


What does answer A mean? That you cannot have it stored in a file in your sourcecode versioning system?
What does C mean? A function by itself has no positional or named notation for parameters; it is the call to the function that has this.

That's what you get from dumps: BS answers.

[Updated on: Mon, 24 November 2008 02:13]

Report message to a moderator

Previous Topic: Inserting
Next Topic: All about Oracle Database 11g, 10g, 9i
Goto Forum:
  


Current Time: Tue Apr 16 16:49:16 CDT 2024