Content deleted Content added
Thumperward (talk | contribs) Added {{Lead too short}} tag |
Link suggestions feature: 2 links added. Tags: Visual edit Mobile edit Mobile web edit Newcomer task Suggested: add links |
||
| (14 intermediate revisions by 9 users not shown) | |||
Line 39:
The first version of SQL Plus was called ''UFI'' ("User Friendly Interface"). UFI appeared in Oracle database releases up to Version 4.
After Oracle programmers had added new features to UFI, its name became ''Advanced UFI''. The name "Advanced UFI" changed to "SQL Plus" with the release of the version 5 of Oracle.<ref>{{cite book |year=2004 |title=Oracle Insights |edition=1st |url=https://books.google.com/books?id=QE5UntUi-4oC&pg=PA35 |page=35| isbn = 978-1590593875|access-date=March 18, 2014|last1=Millsap |first1=Cary |last2=Kolk |first2=Anjo |last3=McDonald |first3=Connor |last4=Gorman |first4=Tim |last5=Hailey |first5=Kyle |last6=Ensor |first6=David |last7=Lewis |first7=Jonathan |last8=Vaidyanatha |first8=Gaja Krishna |last9=Ruthven |first9=David |last10=Morle |first10=James |publisher=Apress }}</ref>
==Usage==
Graphical interfaces from Oracle or third parties have diminished the proportion of [[Oracle Database|Oracle database]] end-users who depend on the SQL Plus environment. Oracle shops typically continue to use SQL Plus scripts for batch updating or simple reports.{{Citation needed|date=November 2008}}
[[Oracle Corporation]]'s wrappers/gui-fications/replacements for SQL Plus include:
* Oracle SQL Plus Worksheet, a component of [[Oracle Enterprise Manager|OEM]]<ref>{{cite web
Line 177:
</ref>
while running a subsequent SQL Plus command.
=== Installation and configuration ===
SQL*Plus needs to be installed and configured on the machine where you intend to use it. This usually involves setting up Oracle client software and configuring network connections to Oracle databases.<ref>{{Cite web |title=Oracle database services and products offer customers cost-optimized and high-performance versions of Oracle Database, the world's leading converged, multi-model database management system |url=https://www.oracle.com/database/}}</ref>
== Supplementary software ==
* [http://www.softtree.com SQL Assistant] SQL Assistant add-on for SQL Plus Windows version extends SQL Plus with SQL automatic word completion, in-line Oracle SQL Reference, data export/import, code [[unit testing]], data browsing, and code development functions.
* [https://web.archive.org/web/20101128023958/http://utopia.knoware.nl/~hlub/uck/rlwrap/ rlwrap] rlwrap does [[GNU]] [[Readline]] like command completion for SQL Plus on [[UNIX]] and [[Linux]].
== See also ==
* [[Oracle SQL Developer]]
* [[Oracle SQL/PLSQL Developer]]
* [[techaid71/most-common-sqlplus-commands]]
==References==
| |||