How to Select an Optional Value

Sometimes in your PL/SQL code you need to query a table which may or may not contain what you're looking for. This post will cover some different ways of doing it. The problem Suppose you need to find an employee's ID named SAM. If he doesn't exist i...