Do you use any free tool to generate query for oracle database. Tool that autocomplete and suggests the table names and column names.
Oracle SQL Developer has auto-complete and such.
Written and maintained by Oracle themselves. It is written in java though, and can be quite slow to respond after being minimized for a while (not that java is the cause, cough, cough).