Revision as of 23:10, 2 November 2020 edit Citation bot (talk \| contribs) Bots 5,864,890 edits 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 ← Previous edit		Revision as of 09:57, 4 January 2021 edit undo Monkbot (talk \| contribs) Bots 3,695,952 edits m Task 18 (cosmetic): eval 12 templates: del empty params (43×); hyphenate params (9×); Tag: AWB Next edit →
Line 2: ==Command types== SQL Plus understands five categories of text:<ref name="CommandRef">{{cite web \| url=http://www.orafaq.com/faq/sqlplus \| title=SQL Plus at orafaq.com \| ~~accessdate~~access-date=2007-11-26 \|~~archiveurl~~archive-url = https://web.archive.org/web/20071109104758/http://www.orafaq.com/faq/sqlplus <!-- Bot retrieved archive --> \|~~archivedate~~archive-date = 2007-11-09}}</ref> # SQL statements 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~~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 }}</ref> ==Usage== Line 50: \|last = Evans \|first = Robert ~~\|authorlink =~~ \|date = 2008-10-01 \|publisher = Cardiff University ~~\|___location =~~ ~~\|pages =~~ ~~\|doi =~~ \|archive-url = https://web.archive.org/web/20081201065932/http://docs.cs.cf.ac.uk/html/601/node4.html \|archive-date = 2008-12-01 \|quote = Oracle's SQL Plus Worksheet is a straight-forward, easy-to-use, graphical user interface for SQL. \|url-status = dead ~~\|df =~~ }} </ref> Line 66 ⟶ 61: \| url = http://www.orafaq.com/wiki/ISQLPlus \| title = ISQLPlus \| ~~accessdate~~access-date = 2008-11-21 ~~\| author =~~ ~~\| last =~~ ~~\| first =~~ ~~\| authorlink =~~ \| date = 2008-02-29 \| publisher = Oracle FAQ ~~\| ___location =~~ ~~\| pages =~~ ~~\| language =~~ ~~\| doi =~~ \| quote = iSQLPlus (iSQL Plus) is a web-based utility similar to the SQL Plus command line utility for executing SQL and PL/SQL commands (available up to Oracle 10gR2). }} Line 84 ⟶ 71: \| title = Oracle SQL Developer 1.5: Feature List \| access-date = 2008-11-21 ~~\| author =~~ ~~\| last =~~ ~~\| first =~~ ~~\| authorlink =~~ ~~\| date =~~ ~~\| year =~~ \| publisher = Oracle Corporation ~~\| ___location =~~ ~~\| pages =~~ ~~\| language =~~ ~~\| doi =~~ \| archive-url = https://web.archive.org/web/20080724133233/http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm#nf_sql \| archive-date = 2008-07-24 Line 105 ⟶ 82: \| title = Oracle Application Express \| access-date = 2008-11-21 ~~\| author =~~ ~~\| last =~~ ~~\| first =~~ ~~\| authorlink =~~ ~~\| date =~~ ~~\| year =~~ \| publisher = Oracle Corporation ~~\| ___location =~~ ~~\| pages =~~ ~~\| language =~~ ~~\| doi =~~ \| archive-url = https://web.archive.org/web/20061021062241/http://www.oracle.com/technology/products/database/application_express/html/what_is_apex.html \| archive-date = 2006-10-21 Line 144 ⟶ 111: \|title= Expert Oracle Database 11g Administration \|url= https://books.google.com/books?id=tdRes4IdLiIC \|~~accessdate~~access-date= 2009-07-29 \|year= 2008 \|publisher= Apress Line 150 ⟶ 117: \|pages= 118–119 \|chapter= 4 \|~~chapterurl~~chapter-url= https://books.google.com/books?id=tdRes4IdLiIC&q=sqlplus+predefined+variable&pg=PA118 }} </ref> Line 157 ⟶ 124: \|first = Natalka \|last = Roshak ~~\|authorlink =~~ \|title = Spice up your SQL Scripts with Variables \|url = http://www.orafaq.com/node/515 \|work = Oracle FAQ ~~\|publisher =~~ ~~\|___location =~~ ~~\|doi =~~ \|date = 2005-11-06 \|~~accessdate~~access-date = 2009-07-29 \|quote = & and && indicate substitution variables in SQL Plus scripts or commands. }} Line 173 ⟶ 136: \|first = René \|last = Nyffenegger ~~\|authorlink =~~ \|title = Using bind variables in SQL Plus \|url = http://www.adp-gmbh.ch/ora/sqlplus/use_vars.html \|work = René Nyffenegger's collection of things on the web \|~~publisher~~ access-date = 2009-07-29 ~~\|___location =~~ ~~\|doi =~~ ~~\|date =~~ ~~\|year =~~ ~~\|accessdate = 2009-07-29~~ \|quote = In SQL Plus, a bind variable is declared with <code>variable</code> [...] The value of the bind variable can then be printed with <code>print</code> }}

SQL Plus: Difference between revisions