Basic HTML version of Foils prepared 7 October 97

Foil 12 Data Types and Operators in Oracle SQL

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
varchar2, number, long, date, raw, long raw, rowid, char
Operators in Oracle SQL
  • arithmetic operators: +, -, *, /
  • character operators: || (concatenation)
  • comparison operators: =, !=, >, <, >+, <=, IN, NOT IN, ANY, SOME, ALL, between x AND y, exists, x like y, IS NULL
  • logical operators: not, and, or
  • set operators: union, union all, intersect, minus
see handout for details

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998