Search code examples
oraclesqldatatypes

SQL Server to Oracle Datatype conversion

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

Solution

  • 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.