YASQL is an open source Oracle command line interface. It features a much kinder user interface than SQL*Plus (sqlplus). This is meant to be a complete replacement for SQL*Plus when dealing with ad hoc queries and general database interfacing. It adds features such as full ReadLine support for command history and tab completion, alternate output methods, table, list, CSV, redirection and piping of query results, query editing, scripting, and easy administrative data dictionary commands.
|Tags||Database Front-Ends Office/Business Software Development Systems Administration Database Engines/Servers|
Release Notes: This release adds a new mode, new commands, command completion, additional redirectors, and various fixes.
Release Notes: New features include batch mode, connection as sysdba, and some minor convenience changes.
Release Notes: A new DESC method that is as fast as SQL*PLus, support for PL/SQL and external authentication, and many other enhancements and bugfixes.
Release Notes: Compatibility issues with the data dictionary in Oracle 7 have been fixed. Compound indexes are now ordered. Objects from other schemas no longer conflict . declare and end in will only match if on a blank line. '/' terminator will only match if at the end of a line. Edit temp file now appends '.sql' to the end for syntax highlighting. The SQLPATH environment variable is now used when searching for scripts. Terminal setup is now after script parsing, so that it will work when run under cron.
Release Notes: A fix for a bug where parentheses were matching improperly.