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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.