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!

Features[edit]

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