OraFAQ Forum: SQL & PL/SQL » Related to Select.....Functions

Home » SQL & PL/SQL » SQL & PL/SQL » Related to Select.....Functions

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

Wed, 27 August 2008 10:52

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

Wed, 27 August 2008 11:03

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

Wed, 27 August 2008 12:46

pablolee
Messages: 2882
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

Report message to a moderator

Wed, 27 August 2008 23:23

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...

Report message to a moderator

Wed, 27 August 2008 23:39

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??

Report message to a moderator

Thu, 28 August 2008 00:53

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

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

Report message to a moderator

Thu, 28 August 2008 00:56

ajayrajesh
Messages: 8
Registered: August 2008

Junior Member

"" you cannot call all functions. "" means to which functions we cannot call ??

Report message to a moderator

Thu, 28 August 2008 01:22

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

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

Report message to a moderator

Thu, 28 August 2008 01:28

ajayrajesh
Messages: 8
Registered: August 2008

Junior Member

thanks for your valuable replies

Report message to a moderator

Previous Topic:	NestedTable
Next Topic:	Materialized View

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 14:53:38 CST 2024