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.
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 ...