Modify length of VARCHAR2 column

View All Public Scripts Login to Run Script

Script Name Modify length of VARCHAR2 column
Visibility Unlisted - anyone with the share link can access
Description This script demonstrates how to change the length of a VARCHAR2 column
Area SQL General / DDL
Contributor Oracle
Created Thursday July 14, 2016

Statement 1

create table chaps (name varchar2(25))

Table created.

Statement 2

insert into chaps (name) values ('Herbert Johannes Strauss')

1 row(s) inserted.

Statement 4

alter table chaps modify (name varchar(40))

Table altered.

Statement 5

insert into chaps (name) values ('Gerald Sebastian Rainer Klaus Venzl')

1 row(s) inserted.

Additional Information