To rearrange the columns in an Oracle table, you can use the ALTER TABLE statement with the MODIFY clause.
Syntax:
ALTER TABLE table_name MODIFY
(column_name1 column_definition,
column_name2 column_definition,
...,
column_nameN column_definition);
Example:
Suppose you have a table named "employees" with the following columns:
If you want to rearrange the columns in the following order:
you can use the following SQL statement:
ALTER TABLE employees MODIFY
(emp_name VARCHAR2(50),
emp_salary NUMBER(10,2),
emp_dept VARCHAR2(50),
emp_id NUMBER(5));
This statement will modify the table "employees" by rearranging the columns as specified in the MODIFY clause.
Asked: 2022-07-19 11:00:00 +0000
Seen: 17 times
Last updated: Dec 18 '21