YaSQL

From Oracle FAQ
Jump to: navigation, search

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!

[edit] 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

[edit] External links