varchar and char

[akkerend]

In PL/SQL you can use VARCHAR2(32768). In SQL the limit is 4000 for VARCHAR2, you cannot create a table with column VARCHAR2(32768).