Suppose we have an employee table like this :
SQL> SELECT * FROM EMPLOYEE;
ID NAME SALARY HIRE EMAIL DEPT_ID MANAGER_ID JOB_ID
------ ----------- ---------- --------- ------------------- ---------- ---------- ----------
1 TEDY 11500000 05-JAN-09 tedy@apt.co.id 2 3
2 BUDY 2750000 01-SEP-02 budy@apt.co.id 1 1 3
3 EDDY 49750000 09-MAY-03 eddy@apt.co.id 1 1 2
4 LILIS 5200000 02-JUN-01 lilis@apt.co.id 2 1 4
5 MANUS 1950000 29-OCT-10 manus@apt.co.id 3 2 6
6 TONY 2300000 02-NOV-03 tony@apt.co.id 4 2 1
7 YANNI 1500000 01-MAR-10 yanni@apt.co.id 3 2 5
7 rows selected.
SQL>
In this example we want to change column ID to be EMPLOYEE_ID, the command to do that is like this :
SQL> ALTER TABLE EMPLOYEE RENAME COLUMN ID TO EMPLOYEE_ID; Table altered. SQL>
See that after run ALTER command above, now we have EMPLOYEE_ID column.
SQL> SELECT * FROM EMPLOYEE;
EMPLOYEE_ID NAME SALARY HIRE EMAIL DEPT_ID MANAGER_ID JOB_ID
----------- --------- ---------- --------- ------------------- ------- ---------- -------
1 TEDY 11500000 05-JAN-09 tedy@apt.co.id 2 3
2 BUDY 2750000 01-SEP-02 budy@apt.co.id 1 1 3
3 EDDY 49750000 09-MAY-03 eddy@apt.co.id 1 1 2
4 LILIS 5200000 02-JUN-01 lilis@apt.co.id 2 1 4
5 MANUS 1950000 29-OCT-10 manus@apt.co.id 3 2 6
6 TONY 2300000 02-NOV-03 tony@apt.co.id 4 2 1
7 YANNI 1500000 01-MAR-10 yanni@apt.co.id 3 2 5
7 rows selected.
SQL>