Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of modifying the field length of oracle. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

How to modify field length by oracle

Use the modify keyword to modify the data type: alter table table name modify field name data type

1. Data is already stored in the table

ALTER table tableName MODIFY (Field name Field Type (length))

Eg:

Alter table dpsm_dm_drugslog modify (person VARCHAR2 (30))

2. There is no data in the table:

ALTER TABLE TABLENAME MODIFY ID CHAR (16)

Eg:

Alter table dpsm_dm_drugslog modify person VARCHAR2 (30)

Introduction to Oracle database:

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It is a leading product in the field of database. It can be said that Oracle database system is a popular relational database management system in the world at present. The system has good portability, easy to use and strong function, and is suitable for all kinds of large, medium, small and microcomputer environments. It is a database solution with high efficiency and good reliability, which adapts to high throughput.

On the oracle to modify the length of the field method to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.