What is the difference between procedure and stored procedure? - Procedure are used in VB.NET.There are two types of procedures in Vb.NET:1-Sub Procedures 2- Function Procedures Stored Procude is the term used in SQL servere programming for sub procedure as in VB.NET.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What is the difference between procedure and stored procedure?

Answer: Procedure are used in VB.NET.There are two types of procedures in Vb.NET:1-Sub Procedures 2- Function Procedures

Stored Procude is the term used in SQL servere programming for sub procedure as in VB.NET.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7646 users
Added on	10/19/2013
Views	66744
Rate it!

Question: What is the difference between procedure and stored procedure?

Answer:

Procedure are used in VB.NET.There are two types of procedures in Vb.NET:1-Sub Procedures 2- Function Procedures

Stored Procude is the term used in SQL servere programming for sub procedure as in VB.NET. Source: CoolInterview.com

Answered by: Hari Om Pandey | Date: 8/11/2009 |

Contact Hari Om Pandey

Since here question is Procedure vs stored procedure

Procedure is the normal ananymous PLSQL block which has been ran every time when needed.

Stored procedure refers to the named procedure stored in database Which can be refered at any time by calling procedure name. Source: CoolInterview.com

Answered by: sam | Date: 4/14/2010 |

Contact sam

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	what is pga ?	View Answer
	what is pga ?	View Answer
	What is component of sga?	View Answer
	What is function overloading?an example of function overloading in oracle?	View Answer
	I have use three select statement in inside prcedure body both three select statment given no_data_found exception but i handled only one exception in exception section but i want to know which select statment given no_data_found?	View Answer
	Diffrence between VIEW and MATERIALIZED VIEW?	View Answer
	I would like to know the detail coding and procedure of connecting Oracle and Sql with VB and VB.Net	View Answer
	What are Drawback of cursor?	View Answer
	What is a basic difference between having and where clause?	View Answer
	Why oracle is the best database?	View Answer
	I WANT TO BECOME A DBA ADMINISTRATOR. SO,FOR THAT WHAT CAN I PREPARE NOW?	View Answer
	What is Trigger at one Line?	View Answer
	If the application is running very slow? At what points you need to go about the database in order to improve the performance?	View Answer
	Explaint the nvl2 function	View Answer
	what is place holder column? where we can use other than formula column?	View Answer
	What is the difference between groupby and orderby?	View Answer
	What is the process of upgrading oracle forms /reports from older version to new versions?	View Answer
	How many codds rule should oracle satisfies	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode