Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hr@tgksolutions.com
A stored procedure is a precompiled collection of SQL statements stored in the database. It improves performance and security by reducing query execution time.
Example:
CREATE PROCEDURE GetUsers()
AS
BEGIN
SELECT * FROM Users;
END;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is keys and its types?
What are database links used for?
What is difference between inner join and cross join?
what is oracle database ? : Sql dba
What operators deal with null?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is sql and db2?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is cold data?
What is the difference between a database and a relational database?
What are the syntax and use of the coalesce function?
How many functions are there in sql?
Explain two easy sql optimizations.
What are sql procedures?
What is sql character function?
