| Publisher | Oracle | ||
|---|---|---|---|
| Format | HTML | Date added | 01 Mar 2006 |
| Topics | Database Applications | ||
| Downloads | 169 | ||
A bind variable is a placeholder in a SQL command for a value that will be supplied at runtime by the application. Because one can change the value of the bind variable as many times as needed without changing the actual text of the SQL command, the database can reuse the same statement over and over without incurring the overhead of reparsing the command each time it's executed. If a person wants to build higher-performance, secure applications, he or she should know how bind variables work. This paper discusses how to use them in J2EE applications built with Oracle Application Development Framework (ADF).
Did you find this white paper useful?
24 out of 50 users found this white paper useful
Related white papers
Improving the Accuracy of Spend Analysis through Data Quality
Organisations can spend as much as 60 percent of revenue to acquire the goods and services necessary to conduct business. Procurement professionals are being asked to reduce the organisation's overall...
The ROI of Data Governance: Seven Ways Your Data Governance Program Can Help Save You Money
In difficult economic climates, responsible leaders look for opportunities to contain costs. Data governance programs are well positioned to assist in these efforts. This white paper from Gwen Thomas of...
Observing Data Quality Service Level Agreements
This white paper by David Loshin from Knowledge Integrity examines how to measure data quality and what to do when the data does not meet the level of acceptability. When...
Populating a Data Quality Scorecard with Relevant Metrics
Too often, data governance teams rely on existing measurements as the metrics used to populate a data quality scorecard. But without a defined understanding of the relationship between specific measurement...
Log4plsql: Open-Source Tool for PL/SQL Logging
The implementation of logs is a significant element in development strategy: exhaustive yet concise logs are required to enable code debugging and the tracing of functional events. At the same...
State Bank of Mauritius Improves Reporting Capabilities Using Oracle Technology
Founded in 1973, State Bank of Mauritius (SBM) is the country's second largest domestic bank in terms of assets. The bank wanted to expand use of technology to improve financial...
Understanding System Statistics
Although system statistics haven't yet achieved much popularity, they are not only important overall but actually critical to certain optimization options in 10g. System statistics give the optimizer more of...
