Can we use bind variables in oracle stored procedure?
Answer / Babita Singh
Yes, binding variables are used in Oracle stored procedures to improve performance by avoiding the need to recompile the entire procedure when only a small part of it changes. They also help prevent SQL Injection attacks.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can Oracle users be audited?
where do i find oracle interview questions.
How to use like conditions in oracle?
Explain the use of log option in exp command.
When a form is invoked with call_form, Does oracle forms issues a save point ?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
What is a snapshot log?
How to see the table columns used in an index?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
Why should I use oracle database?
How would you optimize a slow SQL query?
 What are the oracle DML commands possible through an update strategy?