How to modify table field length using oracle

In Oracle, you can use the modify statement to modify the field length of the table. The syntax is "alter table table name modify field name field type field length;". The midify statement can not only modify the field length, but also modify the field type, default value, and comments.

The operating environment of this tutorial: Windows 7 system, Oracle version 11.2.0.1.0, DELL G3 computer.

1. Modify one column

alter table 表名 modify name varchar2(60);

2. Modify multiple columns

alter table 表名 modify (name varchar(60),name1 varchar2(60));

Recommended (free): oracle

The above is the detailed content of How to modify table field length using oracle. For more information, please follow other related articles on the PHP Chinese website!