Content deleted Content added
GrandPoohBah (talk | contribs) added history, afiedt.buf and compatibility |
|||
Line 1:
'''SQL*Plus''' is an [[Oracle database|Oracle]] command line utility which allows users to run [[SQL]] and [[PL/SQL]] commands interactively. Complete documentation for the SQL*Plus interpreter can be found on the Oracle website.
SQL*Plus is a simple tool with a basic command line interface, however it is commonly used as it is almost always available in any Oracle software installation.
==Versions==
'''UFI'''
SQL*Plus's predecessor was called UFI (User Friendly Interface).
UFI was included in the first Oracle database releases up to Oracle v4.
The UFI interface was extremely primitive and, in today's terms,
anything but user friendly. If a statement was entered incorrectly,
UFI issued an error and rolled back the entire transaction (ugggh).
'''Advanced UFI'''
After new features were added to UFI, it was renamed internally to Advanced UFI. The name "Advanced UFI" was never used officially, as the name was changed to SQL*Plus before this version was released.
'''SQL*Plus'''
SQL*Plus is the current name of the product
==afiedt.buf file==
AFIEDT.BUF is the SQL*Plus default edit save file. When you issue the "edit" command, the last SQL or PL/SQL command will be saved to a file called AFIEDT.BUF and opened in the default editor.
In the early days when SQL*Plus was called UFI (User Friendly Interface) this file was initially named "ufiedt.buf", short for UFI editing buffer.
When the product was renamed to Advanced UIF The file name was changed to "aufiedt.buf" and then to "afiedt.buf" to keep the name short enough for compatibility with some of the odd operating systems that Oracle supported in those days.
Although the product has long been renamed to SQL*Plus, the old file is still in use.
==Compatibility==
Various software is known to be somewhat compatible with SQL*Plus script commands or offer a SQL*Plus mode of operation. These include TOAD from Quest and others.
==References==
| |||