Home » SQL & PL/SQL » SQL & PL/SQL » Related to Select.....Functions
Related to Select.....Functions [message #343595] Wed, 27 August 2008 10:52 Go to next message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
Can we call all Functions ( including User-defined ) throgh INSERT statement ??

Will it there be any Constraints ??

[Updated on: Wed, 27 August 2008 10:55]

Report message to a moderator

Re: Related to Select.....Functions [message #343599 is a reply to message #343595] Wed, 27 August 2008 11:03 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Ya it can he used in the Insert statement.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions231.htm

It does not support returning Boolean parameters.

regards,
Dwarak

[Updated on: Wed, 27 August 2008 11:05]

Report message to a moderator

Re: Related to Select.....Functions [message #343636 is a reply to message #343595] Wed, 27 August 2008 12:46 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
1. Lose the stupid font please. It is more likely to get you ignored than a quick answer.

In answer to your question, NO you cannot call all functions.
rtfm
Re: Related to Select.....Functions [message #343727 is a reply to message #343636] Wed, 27 August 2008 23:23 Go to previous messageGo to next message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
can you please tell me the constartints involved in that ...

sorry for the font..that is my first post...
Re: Related to Select.....Functions [message #343731 is a reply to message #343727] Wed, 27 August 2008 23:39 Go to previous messageGo to next message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
In a interview...
Interviewer asked me.... Can we call all functions through Insert statement ???

I answered ..Yes we can...
He said..No..and told me to check..


Can any tell me what is the answer for that plzzzzzzzzz??
Re: Related to Select.....Functions [message #343745 is a reply to message #343731] Thu, 28 August 2008 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in:
pablolee wrote on Wed, 27 August 2008 19:46
In answer to your question, NO you cannot call all functions.
rtfm


Regards
Michel
Re: Related to Select.....Functions [message #343746 is a reply to message #343745] Thu, 28 August 2008 00:56 Go to previous messageGo to next message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
"" you cannot call all functions. "" means to which functions we cannot call ??
Re: Related to Select.....Functions [message #343758 is a reply to message #343746] Thu, 28 August 2008 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Fundamentals
Chapter 7 Coding PL/SQL Procedures and Packages
Section Calling Stored Functions from SQL Expressions

Regards
Michel
icon7.gif  Re: Related to Select.....Functions [message #343761 is a reply to message #343758] Thu, 28 August 2008 01:28 Go to previous message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
thanks for your valuable replies
Previous Topic: NestedTable
Next Topic: Materialized View
Goto Forum:
  


Current Time: Fri Dec 09 21:34:58 CST 2016

Total time taken to generate the page: 0.16086 seconds