Main Article Content
Abstract
The use of variables in computer programming is crucial for enhancing program performance. Variables are widely employed in database programming for queries. Similar to other variables, bind variables are used in databases to improve performance. When bind variables are implemented, the program interpreter uses the address of data instead of actual data values, which prevents repetitive processes in a program or query. This research includes practical examples from Oracle databases, comparing the use and non-use of bind variables. The findings highlight significant performance time differences when bind variables are utilized.
Keywords
Article Details
Copyright (c) 2024 Reserved for Kabul University
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
References
- Cyran, Michele. Oracle Database Concepts, 10g. [ed.] Paul Lane. Release 2. Redwood City : Oracle Corporations, 2005.
- Russell, John. PL/SQL User’s Guide and Reference. [ed.] Tom Portfolio. Release 2. Redwood City : Oracle Corporations, 2002.
- Rick Greenwald, Robert Stackowiak, and Jonathan Stern. Oracle Essentials: Oracle Database 11g. Fourth Edition. North, Sebastopol : O’Reilly Media, Inc, 2008.
- Murray, Chuck. Oracle SQL Developer User's Guide. Release 1.5. USA : Oracle and/or its affiliates, 2013.
- Engsig, Bjørn. Designing applications for performance and scalability. [ed.] Graham Wood, John Rees Lex de Haan. 2nd issue. Redwood Shores : Oracle Corporation, 2005.
- Agrawal, Shashaanka. Oracle Database PL/SQL User’s Guide and Reference 10g. [ed.] Cailein Barclay. Release 2 . Redwood City : Oracle., 2005.
- Sharma, Jayashree. Oracle Database Database Development Guide. [ed.] Louise Morin Amith Kumar. 19c. USA : Oracle and/or its affiliates., 2021.
- PL/SQL and Bind Variable: the two ways to increase the efficiency of Network Databases. SHARMA, Hitesh KUMAR. 4, 2011, Database Systems Journal , Vol. II.
References
Cyran, Michele. Oracle Database Concepts, 10g. [ed.] Paul Lane. Release 2. Redwood City : Oracle Corporations, 2005.
Russell, John. PL/SQL User’s Guide and Reference. [ed.] Tom Portfolio. Release 2. Redwood City : Oracle Corporations, 2002.
Rick Greenwald, Robert Stackowiak, and Jonathan Stern. Oracle Essentials: Oracle Database 11g. Fourth Edition. North, Sebastopol : O’Reilly Media, Inc, 2008.
Murray, Chuck. Oracle SQL Developer User's Guide. Release 1.5. USA : Oracle and/or its affiliates, 2013.
Engsig, Bjørn. Designing applications for performance and scalability. [ed.] Graham Wood, John Rees Lex de Haan. 2nd issue. Redwood Shores : Oracle Corporation, 2005.
Agrawal, Shashaanka. Oracle Database PL/SQL User’s Guide and Reference 10g. [ed.] Cailein Barclay. Release 2 . Redwood City : Oracle., 2005.
Sharma, Jayashree. Oracle Database Database Development Guide. [ed.] Louise Morin Amith Kumar. 19c. USA : Oracle and/or its affiliates., 2021.
PL/SQL and Bind Variable: the two ways to increase the efficiency of Network Databases. SHARMA, Hitesh KUMAR. 4, 2011, Database Systems Journal , Vol. II.