Day 19. Stored Procedures, Triggers, and Embedded SQL

Over the course of the past 18 days, you have examined every major topic used to write powerful queries to retrieve data from a database. You have also briefly explored aspects of database design and database security. Today's objective is to cover advanced SQL topics, which include the following:

  • Temporary tables

  • Cursors

  • Stored procedures

  • Triggers

  • Embedded SQL

Note

Today's examples use Oracle's PL/SQL and Microsoft/Sybase SQL Server's Transact-SQL implementations. We made an effort to give examples using both flavors of SQL wherever possible. You do not need to own a copy of either the Oracle or the SQL Server database product. Feel free to choose your database product based on your requirements. ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition 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.

Start your free trial