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 are the types of indexes that are present inside a database?
how can we view column head in first page but not in remaining pages?
How to do Data integrity testing? Who does this testing (Developer or tester)?
What is the difference between a stored procedure and a query?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is Data Modelling?
issues involved in modeling and building data werahouses
What is the purpose of TNS?
Can we use redis as database?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Explain natural key?
Data structure used to implements a menu:
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
What is the advantage of varchar2 over char?