I am trying to rename a column of multiple tables in Oracle using a cursor over a table that has all the information of other table.
In SQL Server I was able to do it correctly using
sp_rename. I am not able to find an equivalent in Oracle.
I tried with alter table but my table names are in variable so I am not able to do it. I am using:
execute immediate alter table var_table_name rename var_col to var_new_col
Can anyone provide a method that is similar to
sp_rename in Oracle or any other method?