Thursday, June 28, 2012

How to store text that exceeds the VARCHAR2 limit in Oracle?

VARCHAR2 is limited to 4000 bytes. To store text data which exceeds that limit, use a column of type CLOB (Character Large Object), which can hold text up to 4GB.

This is used to store full text of executed SQLs in V$SQL table.

Ref:
http://www.orafaq.com/wiki/CLOB

No comments: