Basic HTML version of Foils prepared 7 October 97

Foil 38 Datatypes in Oracle -III

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
LONG - store variable-length character data containing up to 2 GB
  • non-searchable, i.e., can not be queried as in where, like clause
  • used mostly for text data to be converted when moving among different systems
  • used in data dictionary to store the text of view definitions
  • can be used in SELECT lists, SET clause of UPDATE, and VALUES clause of INSERT
  • some restrictions in SQL statements
RAW and LONG RAW - for data that is not to be interpreted by Oracle. Intended for binary data or byte strings
Oracle allows some restricted implicit datatype conversions and provides a set of SQL functions for explicitly datatype conversions
See associated resources for more details on Oracle datatypes

© 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 Tue Jan 27 1998