describe users;
Name Null? Type
--------- -------- ------------
USER_ID NOT NULL NUMBER(38)
USER_NAME NOT NULL VARCHAR2(30)
EMAIL VARCHAR2(50)
PHONE_NO VARCHAR2(20)
==========================================================================
Add New Columns:
alter table users add ( depart_id varchar(20), department varchar2(20))
==========================================================================
Rename Column name:
alter table users rename column department to depart_name;
==========================================================================
Rename Table Name:
alter table users rename to users_2;
desc users_2;
Name Null? Type
----------- -------- ------------
USER_ID NOT NULL NUMBER(38)
USER_NAME NOT NULL VARCHAR2(30)
EMAIL VARCHAR2(50)
PHONE_NO VARCHAR2(20)
DEPART_ID VARCHAR2(20)
DEPART_NAME VARCHAR2(20)
