Difference between a query and strored procedure?
Answer Posted / khushbu wadhwani
in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How would you convert date into julian date format?
what is data manipulation language? : Sql dba
What type of database is cloud sql?
Explain the savepoint statement.
Can we use ddl statements in stored procedure?
how can we find the number of rows in a table using mysql? : Sql dba
What does data normalization mean?
Is sqlexception checked or unchecked?
what are the different type of normalization? : Sql dba
Can we write dml inside a function in sql server?
What is cursor explain with example?
What is rowid in sql?
State some properties of relational databases?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is auto increment?