rename column oracle

1alter table sales rename column order_date to date_of_order;

1ALTER TABLE my_table RENAME COLUMN old_name TO new_name;
2
3-- To check if column exists before renaming it:
4DECLARE
5    l_cnt INTEGER;
6BEGIN
7    SELECT count(*) INTO l_cnt
8    FROM dba_tab_columns		-- or all_tab_columns (depending on grants)
9    WHERE owner = 'my_schema' AND table_name = 'my_table' 
10    	AND column_name = 'my_col';
11    IF (l_cnt = 1) THEN
12        EXECUTE IMMEDIATE 'ALTER TABLE my_table 
13        	RENAME COLUMN my_col TO my_new_name';
14    END IF;
15END;

1ALTER TABLE table_name
2  RENAME COLUMN old_name TO new_name;