SQL Plus: Difference between revisions

Content deleted Content added
m Reverted edits by Greff379 (talk) to last version by DannyS712 bot
Citation bot (talk | contribs)
Alter: url, chapterurl. URLs might have been internationalized/anonymized. Add: author pars. 1-10. Removed parameters. Some additions/deletions were actually parameter name changes. | You can use this bot yourself. Report bugs here. | Suggested by AManWithNoPlan | All pages linked from cached copy of User:AManWithNoPlan/sandbox2 | via #UCB_webform_linked 771/2860
Line 36:
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|accessdate=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 }}</ref>
 
==Usage==
Line 48:
|title = The SQL Plus Worksheet
|access-date = 2008-11-21
|author =
|last = Evans
|first = Robert
|authorlink =
|coauthors =
|date = 2008-10-01
|year =
|month =
|work =
|publisher = Cardiff University
|___location =
Line 76 ⟶ 71:
| first =
| authorlink =
| coauthors =
| date = 2008-02-29
| year =
| month =
| work =
| publisher = Oracle FAQ
| ___location =
Line 97 ⟶ 88:
| first =
| authorlink =
| coauthors =
| date =
| year =
| month =
| work =
| publisher = Oracle Corporation
| ___location =
Line 121 ⟶ 109:
| first =
| authorlink =
| coauthors =
| date =
| year =
| month =
| work =
| publisher = Oracle Corporation
| ___location =
Line 143 ⟶ 128:
 
==Compatibility==
Other vendors have made their software somewhat compatible with SQL Plus script commands or offer a SQL Plus mode of operation. Relevant products include [[TOAD (software)|TOAD]] from [[Quest Software]].<ref>{{Cite book|url=http://www.informit.com/articles/article.aspx?p=31544&seqNum=17|title=TOAD SQL Editor|lastlast1=Hotka|firstfirst1=Dan|last2=Scalzo|first2=Bert|date=2003-04-18}}</ref>
 
== Integration ==
Line 158 ⟶ 143:
|first= Sam R.
|title= Expert Oracle Database 11g Administration
|url= https://books.google.com/books?id=tdRes4IdLiIC&dq
|accessdate= 2009-07-29
|year= 2008
Line 165 ⟶ 150:
|pages= 118–119
|chapter= 4
|chapterurl= https://books.google.com/books?id=tdRes4IdLiIC&pg=PA118&lpg=PA118&dqq=sqlplus+predefined+variable&sourcepg=bl&ots=7Qx008gycp&sig=PYHPGw7CVSsrKJwaXXLDR_ZtsLc&hl=en&ei=QcFvStL6NYPwsQOx48zNCA&sa=X&oi=book_result&ct=result&resnum=9PA118
}}
</ref>
Line 188 ⟶ 173:
|first = René
|last = Nyffenegger
|author =
|authorlink =
|coauthors =
|title = Using bind variables in SQL Plus
|url = http://www.adp-gmbh.ch/ora/sqlplus/use_vars.html
Line 198 ⟶ 181:
|doi =
|date =
|month =
|year =
|accessdate = 2009-07-29