Chapter 13. Oracle SQL Queries and Transactions

This chapter discusses how to connect to the Oracle Database 10g XE instance to both query and transact against schema objects, such as tables, views, and stored procedures. While Structured Query Language (SQL) provides the standard interface to Oracle databases, Oracle also provides the Procedural Language/ Structured Query Language (PL/SQL) interface. You will cover SQL approaches in this chapter working with both scalar variables. PL/SQL approaches working with scalar, scalar collections, and SQL reference cursors are in Chapter 14.

Chapter 2 demonstrated how to install the Oracle Database 10g XE product and configure and verify a connection. You must have the Apache, Oracle, and PHP product ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.