O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Recognizing errors

To wrap up this chapter, it's time to address what happens when you receive an error in SQL Developer. By this time, it's likely that you may have made a mistake in typing a statement and received an error. Errors can be frustrating, but debugging your code is an essential part of learning to write SQL. To generate an example error, we incorrectly write the following SELECT statement:

SELCT * FROM award;

We receive this error in SQL Developer.

Recognizing errors

Examine the error generated previously. The window that pops up indicates an error was encountered. It lists an error number, ORA-00900, and an error message, "invalid SQL statement". The rest ...

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