WL#936: CLOB and NCLOB
Affects: Server-7.1
—
Status: Un-Assigned
We should allow the CLOB (Character Large OBject) and NCLOB (National Characer Large OBject) data types. CLOB is like VARCHAR, only bigger. NCLOB is like NATIONAL CHAR VARYING, only bigger. Example: CREATE TABLE t (s1 CLOB (1000000)) INSERT INTO t VALUES ('The rain in Spain') The size may be abbreviated using multipliers K,M or G: 'K' for kilobytes 'M' for megabyte or 'G' for gigabyte. For example: CREATE TABLE t (s1 CLOB (1K)) /* size = 1 kilobyte */ CREATE TABLE t (s1 CLOB (1M)) /* size = 1 megabyte */ CREATE TABLE t (s1 CLOB (1G)) /* size = 1 gigabyte */ Space characters may appear between number and multiplier: CREATE TABLE t (s1 CLOB (1 K)) CREATE TABLE t (s1 CLOB (1 M)) CREATE TABLE t (s1 CLOB (1 G)) Optionally, length units can be specified, either CHARACTERS or BYTES: CREATE TABLE t (s1 CLOB (1K CHARACTERS)) CREATE TABLE t (s1 CLOB (1K BYTES))
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.