What is the different between Stored Procedure and Procedure?

Answer Posted / abhishek

Stored procedure is a subprogram in oracle and procedure is an anoyomous block. Stored procedure can be caled by exec at any time wen the user require it for execution..Procedure are created for temporary execution and they are not stored

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define sql delete statement ? : Sql dba

659


Can we use distinct and group by together?

687


Which sorts rows in sql?

679


What is the purpose of design view?

618


What is cold data?

584






What are the possible values that can be stored in a boolean data field?

608


Are dml statements autocommit?

642


What is scalar function?

678


What is varchar example?

658


What is break?

714


How do I count rows in sql query?

583


What is set transaction?

676


What are the steps for performance tuning.

932


When can we use the where clause and the having clause?

663


When is the explicit cursor used ?

672