What is the different between Stored Procedure and Procedure?

Answer Posted / roshan kumar

Procedure-

A procedure is a specified series of actions,acts or operations which have to be executed in the same mannner in order to always obtain the same result under the same circumstances.

Stored Procedure-

A stored procedure is a subroutine available to applicATIONS accessing a Relational database system.stored procedures(sometimes called as proc,sproc or sp) are actually stored in database dictionary.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the commands used in sql?

521


what is row? : Sql dba

705


How is a process of pl/sql compiled?

596


What are the two parts of design view?

578


What does sign mean sql?

565






Is it possible to pass parameters to triggers?

570


Is foreign key mandatory?

552


What does the sign mean in sql?

505


What is linq to sql?

550


How do you optimize a stored procedure in sql?

499


What are the benefits of pl/sql packages?

539


what is cursor. write example of it. What are the attributes of cursor.

743


What does count (*) mean?

521


Can we call a function containing dml statements in a select query?

539


What is a temporal data type?

593