Toad World® Forums

Qualify columns with table name/alias in existing SQL


#1

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