OraFAQ Forum: SQL & PL/SQL » Interview Question

Home » SQL & PL/SQL » SQL & PL/SQL » Interview Question (oracle 11g)

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

Interview Question [message #638549]

Mon, 15 June 2015 01:37

anniepeteroracle
Messages: 47
Registered: March 2012
Location: bangalore

Member

Hi
Here I have two Interview questions , which is a common question but the discussion
of this answer is very Interesting .

1) when should I go for procedure or function in PL/SQL?

2) when should I go for procedure or package in PL/SQL?

So please provide the answers for above two questions.

Annie

Report message to a moderator

Re: Interview Question [message #638550 is a reply to message #638549]

Mon, 15 June 2015 01:46

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1) FAQ, already answered many times here, please do search.
2) FAQ, already answered many times here, please do search. This is also explained in details in the documentation:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Report message to a moderator

Re: Interview Question [message #638551 is a reply to message #638550]

Mon, 15 June 2015 01:50

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

1) When you can't do it in SQL
2) When you can't do it in SQL

However, to actually answer it fully (and I'm not expanding for you here as you should learn) you need to be able to explain and justify those answers, the links Michel gave are a good start.

Report message to a moderator

Re: Interview Question [message #638552 is a reply to message #638551]

Mon, 15 June 2015 01:55

anniepeteroracle
Messages: 47
Registered: March 2012
Location: bangalore

Member

Yes the answer is when we can't do it in SQL we go for PL/SQL
But when we will choose procedure and when we will choose package
and same function and procedure.

Of-course the link provided by Michel is very good.

Report message to a moderator

Re: Interview Question [message #638553 is a reply to message #638552]

Mon, 15 June 2015 02:06

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

anniepeteroracle wrote on Mon, 15 June 2015 12:25

But when we will choose procedure and when we will choose package

See this AskTom link.

Report message to a moderator

Previous Topic:	IBM DB2 to Oracle PLSQL Current Day and day code conversion
Next Topic:	How to alter the varchar column to number datatype

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 01:59:32 CDT 2024