Thursday, February 25, 2016

Equivalent type TEXT MySQL in Oracle

Oracle has BLOB, CLOB and NCLOB for storing binary, character and unicode character data types. You can also specify the LOB storage area which allows a DBA to fine tune the storage if necessary (i.e. putting the LOB data on separate disks)

Check this out : http://docs.oracle.com/cd/B10501_01/server.920/a96524/c13datyp.htm#13754

No comments:

Post a Comment