I'm using Toad for Oracle 10.6 and often write queries like:
SELECT * FROM my_table WHERE k....
But how can I do name completion for the column name (
k... in this case)?
I know that I can write
SELECT * FROM my_table t WHERE t.k....
but I'm looking for a faster way without the need for an alias on the table. How can I do this?