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
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
오라클 10g 에서 iSQLplus 포트변경하기..~~~~  (0) 2006.08.23