Tab completion is something which is missing in the sqlplus and if you have lot of tables with long names or lot of columns then it is sufficiently difficult to type them 🙂
Here is a solution for this problem. Download and install gqlplus. gqlplus is a replcement for sqlplus which supports completion for commands/tablenames and column names. Quite useful.
Oracle SQL*Plus (Photo credit: Manuel Cernuda) Related articles 2 GB File limit on writing file using Oracle SQLPlus in Unix(compscicafe.