Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Oracle SQL Queries and Trans... > Querying and Transacting Using SQL S...

Querying and Transacting Using SQL Statements

The use of static SQL statements has practical limitations. It is impossible to know what your end users will select, insert, update, and delete in your web applications. You need the ability to collect inputs and dynamically search and insert data into your application. You need some type of substitution variable method to have this flexibility.

Oracle bind variables act like substitution variables. They are Oracle structures that let you pass scalar variables into and out of SQL statements and PL/SQL statements in your PHP programs. Bind variables also let you move data across memory spaces. In PHP programs bind variables let you seamlessly pass a PHP variable to Oracle and vice versa.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint