Home » SQL & PL/SQL » SQL & PL/SQL » explicit and implicit functions in oracle
explicit and implicit functions in oracle [message #644043] Tue, 27 October 2015 02:54 Go to next message
letolagal
Messages: 1
Registered: October 2015
Location: 30 hao nam
Junior Member
Hi,

1.) What is the difference between explicit and implicit functions in Oracle any examples?

2.) what are the differences between writing Procedures and functions in side a package and writing them individually?

Thanks in advance.



[Edit MC: remove unrelated link]

[Updated on: Tue, 27 October 2015 03:12] by Moderator

Report message to a moderator

Re: explicit and implicit functions in oracle [message #644044 is a reply to message #644043] Tue, 27 October 2015 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

1) I never heard those terms of "explicit" and "implicit" function; explain your question
2) Please do search before posting FAQ

Re: explicit and implicit functions in oracle [message #644046 is a reply to message #644043] Tue, 27 October 2015 04:02 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
letolagal wrote on Tue, 27 October 2015 13:24


2.) what are the differences between writing Procedures and functions in side a package and writing them individually?



If you are asking why should you use a package than a stand alone procedure then see this https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:7452431376537
Re: explicit and implicit functions in oracle [message #644062 is a reply to message #644043] Tue, 27 October 2015 09:59 Go to previous message
John Watson
Messages: 9003
Registered: January 2010
Location: Global Village
Senior Member
Quote:
1.) What is the difference between explicit and implicit functions in Oracle any examples?

Do you mean what are often called "built-in" functions as opposed to "user defined" functions? If you DESCRIBE SYS.STANDARD you'll see all the built-in functions.
Previous Topic: How to keep only one branch after connect by
Next Topic: Inclusion of duplicate records
Goto Forum:
  


Current Time: Fri Jul 10 10:40:31 CDT 2026