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;