oracle rename column code example
Example 1: rename column ORACLE
alter table sales rename column order_date to date_of_order;
Example 2: oracle rename column
ALTER TABLE my_table RENAME COLUMN old_name TO new_name;
DECLARE
l_cnt INTEGER;
BEGIN
SELECT count(*) INTO l_cnt
FROM dba_tab_columns
WHERE owner = 'my_schema' AND table_name = 'my_table'
AND column_name = 'my_col';
IF (l_cnt = 1) THEN
EXECUTE IMMEDIATE 'ALTER TABLE my_table
RENAME COLUMN my_col TO my_new_name';
END IF;
END;
Example 3: PL SQL MODIFY COLUMN NME
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;