June 2022
Intermediate to advanced
838 pages
21h 1m
English
Content preview from SQL in a Nutshell, 4th Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 9. Storing Logic in the Database
Most relational databases allow you to compartmentalize reusable nuggets of logic in what are called stored procedures and user-defined functions (UDFs). In addition, many relational databases allow you to react to changes in data or even structural changes to the database via the use of triggers. The SQL standard defines a syntax for expressing these. In this chapter we’ll focus on the SQL standard commands for working with casts, cursors, functions, methods, procedures, triggers, and types and to what extent these commands are supported in the databases covered in this book (including any deviations from or extensions to the standard). One particular feature not covered by the latest SQL standard is syntax for creating aggregate functions. All the databases we cover support this, but they deviate widely in their syntax. In addition, the SQL standard does not cover triggers that take action when objects in a database (such as tables, views, and even functions) are added, altered, or dropped. Again, most of the platforms provide such triggers, but with varying syntax, as you will see.
How to Use This Chapter
When researching a command in this chapter:
Read “SQL Platform Support”.
Check Table 9-1.
Look up the specific SQL statement, check the syntax, and read the “Keywords,” “Rules at a glance,” and “Programming tips and gotchas” sections. Do this even if you are looking for a specific platform implementation.
Finally, read the platform-specific ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.