Oracle

Character Strings and Dates

Figo Kim 2006. 8. 27. 00:13
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
- 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.
SELECT last_name,job_id,department_id
FROM employees
WHERE last_name = 'Whalen'


'Oracle' 카테고리의 다른 글

Comparison Conditions  (0) 2006.08.27
Comparison Conditions  (0) 2006.08.27
Character Strings and Dates  (0) 2006.08.27
Limiting the Rows That Are Selected  (0) 2006.08.26
Limiting the Rows That Are Selected  (0) 2006.08.26