Enlarge column width : Change Column Size « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. Change Column Size

Enlarge column width

 
SQL>
SQL>  create table t(
  2      id number,
  3      data varchar2(200) );

SQL>
SQL>
SQL>  Alter table t
  2    modify
  3    (
  4     id number,
  5     data varchar2(255)
  6    );


SQL>
SQL>  Alter table t
  2    ADD
  3    (
  4     data2 varchar2(100)
  5    );


SQL>
SQL>  drop table t;


 

Related examples in the same category