oracle rename column
alter table sales rename column order_date to date_of_order;
0
0
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;
Thank you!
0
0
0
10
ALTER TABLE my_table RENAME COLUMN old_name TO new_name;
-- To check if column exists before renaming it:
DECLARE
l_cnt INTEGER;
BEGIN
SELECT count(*) INTO l_cnt
FROM dba_tab_columns -- or all_tab_columns (depending on grants)
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;
Thank you!
10
0
4
3
RENAME table_name TO new_name;
Thank you!
3
0
Are there any code examples left?
New code examples in category SQL