Try it here
Multiple indexes and VARCHR2

Multiple indexes and VARCHAR2 length in Oracle 12C


Multiple Indexes On the Same Column

Multiple indexes on the same column cannot be created in prior version of Oracle.

With oracle 12c this is possible but multiple indexes must be different types like BitMap,B-Tree etc.

Varchar2 Length to 32,767 Bytes

The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes.


Note -VARCHAR2 length is increased to 32767 in Oracle 12CR2.

Writer profile pic

Arun on Apr 02, 2019 at 12:01 am

This article is contributed by Arun. If you like and would like to contribute, you can write your article here or mail your article to . See your article appearing on the main page and help others to learn.

Post Comment

Comments( 2)

Commenter Profilr Pic

Anonymous on Jan 04, 2019 at 12:00 am

Length of varchar2 from 4,000 to 32,767 bytes has been changed in Oracle 12C release 2 not in release 1.So its present in Oracle 12C R2 version.

Commenter Profilr Pic

Arrrsh on Apr 02, 2019 at 12:00 am

Thanks for the info.<br />I have edited it now.




Forgot Password

Please enter your email address below and we will send you information to change your password.