What is Stored procedure ?
Answer Posted / siva kishore
Def:- Stored Procedure is a set of pre-compiled sql statements.
Advantages:
* No need to compile the sql queries again n again when
using frequently.
* Increases execution performance and also reduces the
burden on the database connection.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Should I store images in database?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is odm in database?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
How many types of normalization? What is the use of it?
What do you mean by database?
WHAT KIND OF TOOL BO IS?
What are indexes in oracle?
aht is the difference b/w network & hierarchial & relational dbms????
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What are different types of clusters present?
what is the full procedure for using store procedure in informatica7.1?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
diff b/w inter process and in process