gqlplus – sqlplus with readline (tab completion)

2012-08-03 1 min read Database

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)

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)

Make any command read line enabled (on *nix)

2010-11-25 1 min read Bash Fedora Linux

Make any command read line enabled (on *nix)

  <td>
    <div class="text codecolorer">
      rlwrap sqlite3 database.db
    </div>
  </td>
</tr>

Enable readline even if the command line application is not using it.

* View this command to comment, vote or add to favourites * View all commands by pykler

commandlinefu.com

by David Winterbottom (codeinthehole.com)

gqlplus – sqlplus with readline (tab completion)

Related articles

Make any command read line enabled (on *nix)

Related articles