CODEWITHSUNDEEP
oracle-databasesqldatatypes
vikky
vikky

Reputation: 171

SQL Server to Oracle Datatype conversion

What is the equivalent of nvarchar(max) from SQL Server in Oracle?

Upvotes: 0

Views: 122

Answers (2)

user330315
user330315

Reputation:

SQL Server's nvarchar(max) stores character data of an "unlimited" length.

The equivalent in Oracle would be NCLOB. Depending on how the database was initialized, CLOB might work just as well.

Upvotes: 3

Ted at ORCL.Pro
Ted at ORCL.Pro

Reputation: 1612

NVARCHAR2(32767) in 12c NVARCHAR2(4000) in 11g

Upvotes: 0

Related Questions