Sql Pl Sql Programming Language Oracle Ivan Bayross Pdf Access
This is where the magic happens in Oracle. PL/SQL allows for "procedural" logic—meaning you can use variables, constants, and types. Bayross excels at explaining: Handling multi-row query results.
When a SQL query returns multiple rows, a standard SELECT INTO statement will fail with a TOO_MANY_ROWS exception. Cursors act as pointers to the context area of the query result, allowing developers to fetch and process multi-row datasets row-by-row. Sql Pl Sql Programming Language Oracle Ivan Bayross Pdf
The content is divided into five distinct sections, starting from basic setup (like installing Oracle 9.1 on Windows) and progressing to advanced database security. This is where the magic happens in Oracle
| Chapter | Topic | Key Concepts Covered | | :--- | :--- | :--- | | 1 | Introduction | History of Oracle, Client/Server architecture, Oracle tools (SQL Plus, Developer). | | 2 | SQL Plus Commands | Setting environment, DESC , EDIT , SAVE , GET , SPOOL , START . | | 3 | DDL (Data Definition Language) | CREATE , ALTER , DROP , RENAME , TRUNCATE – Table structures, Data types. | | 4 | DML (Data Manipulation Language) | INSERT , UPDATE , DELETE , SELECT – Basic CRUD operations. | | 5 | Retrieving Data | WHERE clause, BETWEEN , IN , LIKE , IS NULL , Logical operators (AND/OR/NOT). | | 6 | Sorting & Grouping | ORDER BY , GROUP BY , HAVING clause vs WHERE . | | 7 | Functions | Single-row functions (String, Numeric, Date, Conversion), Group functions ( SUM , AVG , COUNT , MAX , MIN ). | | 8 | Joins & Subqueries | Equi-joins, Non-equi-joins, Self-joins, Outer joins, Correlated subqueries, EXISTS / NOT EXISTS . | | 9 | Set Operations | UNION , INTERSECT , MINUS . | | 10 | Views, Indexes, Sequences | Creating virtual tables, Performance tuning via indexes, Auto-numbering via sequences. | | 11 | Security (DCL) | GRANT , REVOKE – Object privileges & System privileges. | When a SQL query returns multiple rows, a
Managing errors gracefully within your code.
Ivan Bayross’ is a foundational text that remains relevant for anyone starting their journey with Oracle databases. By covering the basics of SQL and the advanced procedural capabilities of PL/SQL, it provides a comprehensive toolkit for developers. Whether you are using a physical copy or a PDF version, mastering the concepts in this book will build a strong foundation for a career in database management.
The book covers creating "User Defined Functions, Procedures, Database triggers and other specific data processing PL/SQL code blocks," all essential for commercial application development. The author also highlights his coverage of "Exception handling, Oracle's default locking and User defined locking," which he describes as "of great interest to commercial application developers". This focus on practical, commercial application development, rather than just academic theory, is a key differentiator of this book.