HOW TO MODIFY A COLUMN NAME AND PARAMETERS

ORACLE CHEATSHEET - ALL ABOUT 'ALTER TABLE' How to add a new column to a table? How to drop a column? How to modify a column? How to Rename a Column?   How to add a new column to a Table? ALTER TABLE EMP ADD SALARY NUMBER(8) NOT NULL;   How to Drop a Column? ALTER TABLE EMP DROP COLUMN SALARY;   How to Modify a Column? ALTER TABLE EMP MODIFY( SALARY VARCHAR2(10) NOT NULL, AGE NUMBER(3) NOT NULL );   How to Rename a Column? ALTER TABLE EMP RENAME COLUMN SALARY TO WAGES;