YaSQL

YaSQL is a free open source Oracle command line interface similar to that of SQL*Plus. YaSQL is meant to be a complete replacement for SQL*Plus with easy command completion and history editing features.

YaSQL stands for Yet Another SQL*Plus replacement. It's a GPL application written in Perl by Jon Nangle and Nathan Shafer and is copyright Ephibian, Inc.

Note: YaSQL is not a front-end to sqlplus!

Features

Some of YaSQL's features:

• Select 5 rows from a table:

YaSQL> SELECT * FROM all_users;5

• Write query output to a file:

YaSQL> SELECT * FROM SYSTEM_PRIVILEGE_MAP; >outfile.lst

• Write query output to a CSV-file (requires Perl module Text::CSV_XS)

YaSQL> SELECT * FROM SYSTEM_PRIVILEGE_MAP\S >outfile.csv

External links

• YaSQL on Sourceforge