View the table structure and modify the table field SQL statement in SQLPLUS in oracle

In SQLPLUS, you can view the table structure in oracle, modify the table field in SQL statement 1, view the table structure in desc table name 2, modify the table field in SQL statement, and use the rename keyword to modify the field name: www.2cto.com alter table name rename column old field name to new field name; Use the modify keyword to modify the Data Type: alter table name modify Field name data type; use the add keyword to add the alter table name to the field name data type; Use the drop column keyword to add the alter table drop column permile field name; Author: chen3888015