Sometimes the simplest tricks just ease your life the nice way.
While typing code in TOAD, I just found out those two handy keyboard shortcuts
<CTRL> + . = Autocompletes tablenames
<CTRL> + T = Popups the list of column names
I want to select everything from emp and dept joined on deptno.
SELECT*FROM E<CTRL+.> e,D<CTRL+.> d where e.<CTRL+T><down><enter>=d.<CTRL+T><enter><CTRL+ENTER>
Especially useful when table and column is not EMP.DEPTNO but WWRTM_CUOTDSOTM_IWUWH_ML.H2OUUP2_NIAGASTSGM_IMUMTUCI 🙂