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
Why is sql*loader direct path so fast?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
How to load data with sql*loader?
Which kind of parameters cannot have a default value in pl sql?
What is a pdo connection?
What is the life of an sql statement?
define sql delete statement ? : Sql dba
what is the difference between blob and text? : Sql dba
What is sql server and ase?
what are the advantages and disadvantages of views in a database? : Sql dba
What is the sql query to display the current date?
what is union, minus and interact commands? : Sql dba
What does stand for in sql?
What is sap sql?
What is the execution plan in sql?