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 is a left join?

498


What is trigger in sql and its types?

528


How do you define a foreign key?

527


What is the purpose of a secondary key?

501


What is the trigger in sql?

530






Can you join a table to itself?

533


What is database sql?

537


What is partition by in sql?

565


Why we use joins in sql?

534


What are sql indexes?

539


Can a table contain multiple foreign key’s?

562


how to install mysql? : Sql dba

575


What is a primary key? Explain

534


How many clustered indexes can you have?

529


What are properties of the transaction?

552