Character Strings and Dates

•      Character strings and date values are enclosed by single quotation marks.

•      Character values are case-sensitive, and date values are format-sensitive.

•      The default date format is DD-MON-RR.

•      SELECT last_name, job_id, department_id FROM   employees WHERE  last_name = 'Jenny' ;