Modifying Oracle database field attributes

The following is a detailed explanation.Oracle Database field attributesModification method. We hope that the content involved in this article will be helpful to you.

Rename the database field:

Alter table table_name rename column old_name to new_name

Add Field

Alter table docdsp add dspcode char (200)

Delete Field

Alter table table_NAME drop column column_NAME

Modify Field Type

Alter table table_name alter column column_name new_data_type

As described above, the field Attribute Modification of the Oracle database can be completed. I believe this will be very helpful for your future work.