Oracle PL/SQL in 10 Minutes, Sams Teach Yourself Sams Teach Yourself Oracle PL/SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 26 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Oracle’s PL/SQL language.
Covering Oracle DBMS versions 10, 11, 12 and XE (Express Edition), this handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more.
Learn how to...
Use PL/SQL in the Oracle environments and toolsConstruct complex PL/SQL statements using multiple clauses and operatorsRetrieve, sort, and format database contentsPinpoint the data you need using a variety of filtering techniquesUse string, date-time, and math functions to manipulate your dataJoin two or more related tablesInsert, update, and delete dataCreate and alter database tablesWork with views, stored procedures, cursors, triggers, and more