If I have an existing SELECT statement with un-qualified column references (e.g. "select empno from emps"), I would like to be able to alias the table(s) then retroactively qualify the column references (e.g. "select e.empno from emps e"). Does this exist in Toad for Oracle? If so, I can't find it, and if not, I would LOVE to have it!
I've used similar functionality in SQL Server via Red Gate's SQL Prompt's "Quality Object Names":
https://documentation.red-gate.com/sp6/formatting-your-code/qualifying-object-names