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

What are the different operators available in sql?

570


What are the advantages of sql?

556


What is thread join () in threading?

536


What is the largest value that can be stored in a byte data field?

516


What is implicit cursor in pl sql?

536






What is output spooling in sql*plus?

549


what is union? : Sql dba

580


What is triggering circuit?

592


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2089


State some properties of relational databases?

580


How do you clear the screen in sql?

599


what are the different index configurations a table can have? : Sql dba

566


What are the benefits of triggers?

595


Why self join is used in sql?

495


What does partition by mean in sql?

511