SQL Programming
Although SQL is not a complete programming language—it lacks I/O statements—the standard does contain statements that perform typical programming language functions such as assignment, selection, and iteration for writing persistent stored modules (PSMs). Stored within the database, these can be executed as triggers (code that is executed when a specific event occurs) or as stored procedures (code that is executed with the SQL CALL statement).
In addition, SQL statements can be added to programs written in high-level programming languages to create stand-alone applications. This appendix looks at both types of SQL programming.
Note: This appendix does not attempt to teach programming concepts. To get the most out of ...
Get Relational Database Design and Implementation, 4th 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.
