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
What is the candidate key used for?
Which is the best graph database?
what is the role of auditor in auditing data oriented applications?
Which database is best to store images?
What is the function of cluster index?
How heap is implemented in database?
How many indexes can be created on a table?
What are the advantages of normalizing a database.
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
if i want to display the name of students such that to which city they belong must have count greaer than two
Explain various types of locks in a transaction? Which is better and why?
What are the tools used for backup and ticketing?
Define stored procedure?
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