What is the different between Stored Procedure and Procedure?
- 7 Answers
- 12597 Views
- Informatica, MIS, I also Faced
- E-Mail Answers
Answer Posted / sachin fulari
In Layman tounge -
---------------
Whenever any named block in PL/SQL is created using CREATE
OR REPLACE clause, and as we compile it will get stored in
database, henceforth other code snippets can call/use this
block which ulimately resides in database after creation
i.e. "stored in database". And thus will move along
database if ever we move the database.
In oracle way -
---------------
A stored procedure is created and stored in the database as
a schema object. Once created and compiled, it is a named
object that can be run without recompiling. Additionally,
dependency information is stored in the data dictionary to
guarantee the validity of each stored procedure.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is right join sql?
How would you reference column values before and after you have inserted and deleted triggers?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What pl/sql package consists of?
What is difference between hql and native sql?
What is the difference between jpql and sql?
What is the difference between rollback and rollback to statements?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is substitution variable?
What is a schema sql?
Is grant a ddl statement?
What is mutating trigger?
How do I add a database to sql?
What sql database should I use?
What is column?
