O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4: Error Handling

In This Chapter

arrow Identifying error conditions

arrow Discovering SQLSTATE

arrow Dealing with whatever comes your way

arrow Using the WHENEVER clause

arrow Checking the diagnostics areas

arrow Seeing an example of a constraint violation

arrow Putting more constraints on an existing table

arrow Interpreting SQLSTATE information

arrow Handling exceptions

Wouldn’t it be great if every application you wrote worked perfectly every time? Yeah, and it would also be really cool to win $210 million in the Powerball lottery. Unfortunately, both possibilities are equally unlikely to happen. Error conditions of one sort ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required