https://www.sqlines.com/ 2026-04-11T11:04:48+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2022-10-10T20:35:51+00:00 https://www.sqlines.com/oracle/datatypes/clob?rev=1665434151&do=diff In Oracle, CLOB data type stores variable-length character data (character large object) in the database character set that can be single-byte or multibyte (supports more than 4 GB). In SQL Server, you can use VARCHAR(max) or NVARCHAR(max) to store stores variable-length character data up to 2 GB. text/html 2012-09-14T08:18:44+00:00 https://www.sqlines.com/oracle/datatypes/date?rev=1347610724&do=diff In Oracle, DATE data type stores date and time data (year, month, day, hour, minute and second). Oracle DATE Internals A DATE value requires 7 bytes in Oracle: Byte 1 Byte 2 Byte 3 Byte 4 Byte 5 Byte 6 Byte 7 Century + 100 MOD(Year/100) + 100 Month Day Hour + 1 Minute + 1 Second + 1 The first byte stores the first 2 digits of the year (century) plus 100 . The second byte stores the last 2 digits of the year plus 100. text/html 2012-06-04T14:07:30+00:00 https://www.sqlines.com/oracle/datatypes/raw?rev=1338818850&do=diff In Oracle, RAW data type allows you to store variable-length binary data up to 2000 bytes. You can convert Oracle RAW(n) to VARBINARY(n) in SQL Server. Oracle Example: -- Define a table with RAW column CREATE TABLE rawdata ( c1 RAW(11) ); -- Insert one byte (value 1) INSERT INTO rawdata VALUES ('1');