32K VARCHAR2 columns

View All Scripts Login to Run Script

Script Name 32K VARCHAR2 columns
Description New with Oracle database 12c you can create tables that have VARCHAR2(32767), which is longer then the 11g maximum of 4000.
Area Oracle 12c
Contributor Mike Hichwa (Oracle)
Created Monday October 05, 2015

Statement 1

Create table with a length of greater then 4000.

create table test_larger_varchar (  
    id       NUMBER GENERATED ALWAYS AS IDENTITY,  
    large_vc  VARCHAR2(32767) not null )

Table created.

Statement 2

Insert a row.

insert into test_larger_varchar (large_vc) values ('testing')

1 row(s) inserted.

Statement 3

select * from  test_larger_varchar


ID LARGE_VC
1 testing

ID	LARGE_VC
1	testing

Statement 4

Update the row setting the value to a long string.

update test_larger_varchar set large_vc = rpad(large_vc,10000,'x') where id = 1

1 row(s) updated.

Statement 5

Validate the length.

select length(large_vc) from test_larger_varchar


LENGTH(LARGE_VC)
10000

LENGTH(LARGE_VC)
10000

Additional Information