Home  >  Article  >  Database  >  How to modify table field length using oracle

How to modify table field length using oracle

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-04-27 17:34:5054893browse

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.

How to modify table field length using oracle

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn