I am creating a datamart from a sofwtare tool that is creating a table with random column names (I have no control over it)
their technical support says that after the datamart creation is successful they offer a way to issue a post sql statement via which I can modify the column names.
The problem I have is I need to modify three column names from one sql
alter table random_table_name RENAME COLUMN abc to 123, def to 456, ghi to 789
If I do that then I am getting odbc errors from oracle.
How can i do this ? If sql doesn't allow it then can you write a stored procedure for me which I can then compile on my database and then call the procedure from the post sql statement