Oracle
Character Strings and Dates
Figo Kim
2006. 8. 27. 00:13
- 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.
- NUmber constants should not be enclosed by single quotation marks.
- Oracle databases store dates in an internal numberic format, representing the century, year,month,day,hours,minutes, and seconds.
- Character values are case-sensitive, and date values are format-sensitive.
- The default date format is DD-MON-RR.
- NUmber constants should not be enclosed by single quotation marks.
- Oracle databases store dates in an internal numberic format, representing the century, year,month,day,hours,minutes, and seconds.
SELECT last_name,job_id,department_id
FROM employees
WHERE last_name = 'Whalen'