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.

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

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

Python if , elif and else

Python Conditions and If statements

  • 0
Python for beginners

Learning Python Part 1

  • 3
Struct Alignment and Padding

Struct Alignment and Padding in C++ And C

  • 0
Friend function

Friend function C++

  • 0

C++ Pointers

  • 0

C++ Structures

  • 0
Types of Inheritance in C++

Inheritance and access specifiers C++

  • 0
Java date pattern

Java Date Pattern Syntax

  • 0
Java Date and Calendar

Java Date formats

  • 0
JAVA Data Type

Data types in Java

  • 0
Java unreachable code

Unreachable Code Error in Java

  • 0

Post Comment


Commenter Profilr Pic

Anonymous on Jan 04, 2019 at 05:10 pm

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 04:28 pm

Thanks for the info.
I have edited it now.




Forgot Password

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