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!
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