This book is aimed at PHP developers who are developing applications against an Oracle database. You may already be using another database and have a requirement or a preference to move to Oracle. You may be starting out with PHP database development. You may be unsure how to install PHP and Oracle. This book aims to remove any confusion.
Read the rest of this entry »

Oracle C++ Call Interface (OCCI) is an Application Programming Interface (API) that provides C++ applications access to data in an Oracle database. OCCI enables C++ programmers to utilize the full range of Oracle database operations, including SQL statement processing and object manipulation. Read the rest of this entry »

To increase efficiency and lower costs, companies adopt strategies to automate business processes. One such strategy is to conduct more business on the Web, but that requires greater computing power, translating to higher IT costs.
Read the rest of this entry »

A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but can include data from other sources.
Read the rest of this entry »

This section covers some basic terminology of Java application development in the Oracle Database environment. The terms should be familiar to experienced Java programmers.
Read the rest of this entry »

JDBC (Java Database Connectivity) is a standard Java interface for connecting fromJava to relational databases. The JDBC standard was defined by Sun Microsystems,allowing individual providers to implement and extend the standard with their own JDBC drivers.
Read the rest of this entry »

Dr. E. F. Codd published the paper, ‘A Relational Model of Data for Large Shared Data Banks’, in June 1970 in the Association of Computer Machinery (ACM) journal, Communications of the ACM.
Read the rest of this entry »

The IT systems of today are growing more complex with each iteration of new technology. It is not unheard of to have 2,600 instances to manage. These instances can be as close as next door or on the other side of the world.
Read the rest of this entry »

Oracle XML DB provides high-performance storage and retrieval of XML. It extends Oracle Database, by delivering the functionality associated with both a native XML database and a relational database. It include the following features: Read the rest of this entry »

The PL/SQL language is tightly integrated with SQL. You do not have to translate between SQL and PL/SQL datatypes: a NUMBER or VARCHAR2 column in the database is stored in a NUMBER or VARCHAR2 variable in PL/SQL.
Read the rest of this entry »