Oracle

Comparison Conditions

Figo Kim 2006. 8. 27. 00:18
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
  • BETWEEN ... AND ... : Between two values (inclusive)
    ex) BETWEEN lower_value AND higher_value
  • IN (set) Match any of a list of values
    The IN condition can be used with any data type.
    If characters or dates are used in the list, they must be enclosed by single quotation marks.('')

    SELECT employee_id, last_name, salary, manager_id
    FROM employees
    WHERE manager_id IN (100,101,201);
  • LIKE : Match a character pattern
    To perform wildcard searches of valied search string values.
    Search conditions ca contain either literal characters or numbers.
    - % denotes zero or many characters.
    - "_" denotes one character.
    - When you need to have an exact match for the actaul '%' and _ character, use the ESCAPE option
    SELECT first_name
    FROM employees
    WHERE first_name LIKE 'S%'

    SELECT employee_id, last_name,job_id
    FROM employees
    WHERE job_id LIKE '%SA\_%' ESCAPE'\'

  • IS NULL : Is a null value  (IS NOT NULL)

    SELECT last_name,manager_id
    FROM employees
    WHERE manager_id IS NULL


  • ETC : =,<,>,>=,<=,<>,^=, !=



'Oracle' 카테고리의 다른 글

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