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.

Related articles

• 2 GB File limit on writing file using Oracle SQLPlus in Unix(compscicafe.wordpress.com)

  ---

• Find version of Oracle(sqlandplsql.com)

  ---

• Oracle: Using SQLPLUS and SQLLDR on databases without TNSNAMES entry(hs2n.wordpress.com)

  ---

• Another Reason Why You Should Upgrade Your Oracle Client Software(bobbydurrettdba.com)

  ---

Related Articles:

• 2012/02/27   Oracle Select the top 5 queries
• 2010/11/25   Make any command read line enabled (on *nix)
• 2010/06/04   SQuirrel SQL for Graphical interface to Oracle/MySQL and loads of other database – OSS and free.
• 2012/02/21   glances – Get a glimpse of the whole system
• 2011/02/06   bash regular expressions