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
Differentiate pl/sql and sql?
explain advantages of innodb over myisam. : Sql dba
What is pl/sql table? Why is it used?
What is difference between my sql and sql?
What is the advantage of index in sql?
Can we use the cursor's to create the collection in PL/SQL?
How many tables can you join in sql?
what is column? : Sql dba
what is cursor. write example of it. What are the attributes of cursor.
What is the usage of the distinct keyword?
explain the difference between delete , truncate and drop commands? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
Why do we need view in sql?
What is procedure in pl sql?
How do I view a procedure in sql?