Images

CHAPTER1

SQL and PL/SQL

Business is often based on knowledge and information, and all the important information is usually in a database. A relational database can only be accessed using the Structured Query Language (SQL), which is a standardized language for managing data held in a relational database management system (RDBMS). The Procedural Language/Structured Query Language (PL/SQL) is Oracle Corporation’s extension of the SQL language that gives you the ability to develop procedural code (for example, IF…THEN…ELSE, loops, and so on) for an Oracle RDBMS.

Introduction to SQL and PL/SQL

The database is the place where all important information ...

Get Real World SQL and PL/SQL: Advice from the Experts 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.