Hello, I have a quite few queries which is written without table aliases like (well, very simple example):
select dummy from dual
Now, I need to refactor the query with a table alias. It is not that important what the alias should be, but say "d" in this case:
select d.dummy from dual d
As I have hundreds of queries, I would like to do this in an automated process, using a tool that can be executed from PL/SQL.
Do you know if this is possible?
Oracle 11g/12 r1