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
In pl/sql, what is bulk binding, and when/how would it help performance?
Is t sql a programming language?
How do you update f as m and m as f from the below table testtable?
write an sql query to find names of employee start with 'a'? : Sql dba
What is bind variable in pl sql?
Is id a reserved word in sql?
What does the file extension accdb stand for?
Define union, minus, union all, intersect ?
What is sql resultset?
Is sql difficult?
Is sql better than access?
what is sql? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
How many types of triggers are there in pl sql?
Explain the purpose of %type and %rowtype data types?