| Publisher | Oracle | ||
|---|---|---|---|
| Format | HTML | Date added | 01 Mar 2006 |
| Topics | Database Applications | ||
| Downloads | 161 | ||
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?
25 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...
Using Oracle Database Transactions in .NET
In this paper, the reader will learn how to use database transactions in Visual Basic .NET (VB.NET) and Visual C# .NET (C#). Specifically, the reader will explore database transactions, use...
Improve Performance in SAP Application Environments
With the exploding growth of data, the typical DBA must spend a significant amount of time on tasks to improve performance and application availability. Achieving these goals in large dynamic...
Offload Reporting To Improve Oracle Database Performance
Is your organization looking for a more cost-effective way to get critical data from Oracle production databases to make business decisions? Hardware upgrades and databases reserved for ad-hoc reporting are...
