https://kk.encyclopedia.kz/index.php?action=history&feed=atom&title=SQL%2APlus
SQL*Plus - Түзету тарихы
2026-04-18T10:28:07Z
Мына уикидегі бұл беттің түзету тарихы
MediaWiki 1.23.3
https://kk.encyclopedia.kz/index.php?title=SQL*Plus&diff=86161&oldid=prev
Moderator: 1 түзету
2025-04-25T19:20:51Z
<p>1 түзету</p>
<table class='diff diff-contentalign-left'>
<tr style='vertical-align: top;'>
<td colspan='1' style="background-color: white; color:black; text-align: center;">← Ескі түзетулер</td>
<td colspan='1' style="background-color: white; color:black; text-align: center;">19:20, 2025 ж. сәуірдің 25 кезіндегі түзету</td>
</tr><tr><td colspan='2' style='text-align: center;'><div class="mw-diff-empty">(айырмашылығы жоқ)</div>
</td></tr></table>
Moderator
https://kk.encyclopedia.kz/index.php?title=SQL*Plus&diff=86160&oldid=prev
Нұрлан Рахымжанов: Cat-a-lot: Тасымалдануда... Санат:Информатика → Санат:Ақпараттану
2016-03-23T12:57:52Z
<p><a href="/index.php?title=%D0%A3%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%93%D0%B0%D0%B4%D0%B6%D0%B5%D1%82%D1%82%D0%B5%D1%80/Cat-a-lot&action=edit&redlink=1" class="new" title="Уикипедия:Гаджеттер/Cat-a-lot (мұндай бет жоқ)">Cat-a-lot</a>: Тасымалдануда... <a href="/index.php?title=%D0%A1%D0%B0%D0%BD%D0%B0%D1%82:%D0%98%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B8%D0%BA%D0%B0&action=edit&redlink=1" class="new" title="Санат:Информатика (мұндай бет жоқ)">Санат:Информатика</a> → <a href="/index.php/%D0%A1%D0%B0%D0%BD%D0%B0%D1%82:%D0%90%D2%9B%D0%BF%D0%B0%D1%80%D0%B0%D1%82%D1%82%D0%B0%D0%BD%D1%83" title="Санат:Ақпараттану">Санат:Ақпараттану</a></p>
<p><b>Жаңа бет</b></p><div>'''SQL*Plus''' - Оракл теру утилитасы <br />
<!-- The most basic Oracle utility, with a basic command-line interface, commonly used by users, administrators, and programmers.<br />
<br />
==Command types==<br />
SQL*Plus understands three categories of text:<ref name="CommandRef">{{cite web | url=http://www.orafaq.com/faq/sqlplus | title=SQL*Plus at orafaq.com | accessdate=2007-11-26 |archiveurl = http://web.archive.org/web/20071109104758/http://www.orafaq.com/faq/sqlplus |archivedate = 2007-11-09}}</ref> <br />
<br />
# SQL statements<br />
# PL/SQL blocks<br />
# SQL*Plus internal commands, for example:<br />
## environment control commands such as SET<br />
## environment monitoring commands such as SHOW<br />
<br />
Scripts can include all of these components.<br />
<br />
An Oracle programmer in the appropriately configured software environment can launch SQL*Plus, for example, by entering:<br />
<br />
<code>sqlplus scott/tiger</code><br />
<br />
where the Oracle user <code>scott</code> has the password <code>tiger</code>. SQL*Plus then presents a prompt with the default form of:<br />
<br />
<pre>SQL&gt;</pre><br />
<br />
Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example:<br />
<br />
<pre>SQL&gt; select 'Hello world' as example from dual;<br />
<br />
EXAMPLE<br />
--------------------------------<br />
Hello world</pre><br />
<br />
== History ==<br />
<br />
The first version of SQL*Plus was called ''UFI'' ("User Friendly Interface"). UFI appeared in Oracle database releases up to Version 4.<br />
<br />
After Oracle programmers had added new features to UFI, its name became ''Advanced UFI''. The name "Advanced UFI" changed to "SQL*Plus" before the release of this{{Which?|date=July 2009}} version.<br />
<br />
{{As of |2012|1}} the product continues to bear the name ''SQL*Plus''.<br />
<br />
==Usage==<br />
<br />
Graphical interfaces from Oracle or third parties have diminished the proportion of 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}}<br />
<br />
Oracle Corporation's wrappers/gui-fications/replacements for SQL*Plus include:<br />
<br />
* Oracle SQL*Plus Worksheet, a component of [[Oracle Enterprise Manager|OEM]]<ref>{{cite web<br />
| url = http://docs.cs.cf.ac.uk/html/601/node4.html<br />
| title = The SQL*Plus Worksheet<br />
| accessdate = 2008-11-21<br />
| author = <br />
| last = Evans<br />
| first = Robert<br />
| authorlink = <br />
| coauthors = <br />
| date = 2008-10-01<br />
| year = <br />
| month = <br />
| work = <br />
| publisher = Cardiff University<br />
| location =<br />
| pages = <br />
| doi = <br />
| archiveurl = <br />
| archivedate = <br />
| quote = Oracle's SQL*Plus Worksheet is a straight-forward, easy-to-use, graphical user interface for SQL.<br />
}}<br />
</ref><br />
* iSQL*Plus or iSQLPlus, a web-based utility<ref>{{cite web<br />
| url = http://www.orafaq.com/wiki/ISQLPlus<br />
| title = ISQLPlus<br />
| accessdate = 2008-11-21<br />
| author = <br />
| last = <br />
| first = <br />
| authorlink = <br />
| coauthors = <br />
| date = 2008-02-29<br />
| year = <br />
| month = <br />
| work = <br />
| publisher = Oracle FAQ<br />
| location =<br />
| pages = <br />
| language = <br />
| doi = <br />
| archiveurl = <br />
| archivedate = <br />
| 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). <br />
}}<br />
</ref><br />
* SQL Worksheet,<ref>{{cite web<br />
| url = http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm#nf_sql<br />
| title = Oracle SQL Developer 1.5: Feature List <br />
| accessdate = 2008-11-21<br />
| author = <br />
| last = <br />
| first = <br />
| authorlink = <br />
| coauthors = <br />
| date = <br />
| year = <br />
| month = <br />
| work = <br />
| publisher = Oracle Corporation<br />
| location =<br />
| pages = <br />
| language = <br />
| doi = <br />
| archiveurl = <br />
| archivedate = <br />
| quote = The SQL*Plus commands supported by Oracle SQL Developer SQL Worksheet are listed [...]<br />
}}<br />
</ref> a component of [[Oracle SQL Developer]]<br />
* SQL Workshop (part of [[Oracle Application Express]])<ref>{{cite web<br />
| url = http://www.oracle.com/technology/products/database/application_express/html/what_is_apex.html<br />
| title = Oracle Application Express<br />
| accessdate = 2008-11-21<br />
| author = <br />
| last = <br />
| first = <br />
| authorlink = <br />
| coauthors = <br />
| date = <br />
| year = <br />
| month = <br />
| work = <br />
| publisher = Oracle Corporation<br />
| location =<br />
| pages = <br />
| language = <br />
| doi = <br />
| archiveurl = <br />
| archivedate = <br />
| quote = SQL Workshop provides tools to enable you to view and manage database objects from a Web browser. Use SQL Commands to run SQL and PL/SQL statements. ...<br />
}}<br />
</ref><br />
<br />
=== Oracle 11g ===<br />
Starting from Oracle database 11g, iSqlplus (web based) and sqlplus graphical GUI no longer ship with Oracle database software.<ref>[http://download.oracle.com/docs/cd/B28359_01/install.111/b32006/whatsnew.htm#BGGBABGJ Deprecated Components in Oracle Database 11g Release 1 (11.1)], retrieve by 25-Jun-2009</ref><br />
The command-line SQL*Plus interface continues in use, mostly{{Citation needed|date=July 2009}} for non-interactive scripting or for administrative purposes (<code>connect internal</code> before Oracle 8i; <code>sqlplus ... as sysdba</code> later).<br />
<br />
==Compatibility==<br />
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]].{{Citation needed|date=November 2008}}<br />
<br />
== Integration ==<br />
{{Expand section|date=July 2009}}<br />
<br />
=== Variables ===<br />
<br />
SQL*Plus-internal variables, accessible within an SQL*Plus session, include:<br />
<br />
* user variables, displayable with the DEFINE command and referenceable with one or two cases of a prefixed character (default prefixes: '&' and '&&'). These variables are called "substitution variables" and can be used anywhere in a SQL or PL SQL statement or in SQL Plus commands. They can be populated by a literal using DEFINE or from the database using the column command. <br />
** predefined variables, prefixed with an underscore ('_')<ref><br />
{{cite book<br />
|last= Alapati<br />
|first= Sam R.<br />
|authorlink=<br />
|coauthors=<br />
|firstn=,lastn=<br />
|authorn-link<br />
|editor=<br />
|editorn=<br />
|editorn-last<br />
|editorn-first<br />
|editor-link<br />
|editorn-link<br />
|others=<br />
|title= Expert Oracle Database 11g Administration<br />
|url= http://books.google.com/books?id=tdRes4IdLiIC&dq<br />
|format=<br />
|accessdate= 2009-07-29<br />
|edition=<br />
|series=<br />
|volume=<br />
|date=<br />
|origyear=<br />
|year= 2008<br />
|month=<br />
|publisher= Apress<br />
|location=<br />
|isbn= 978-1-4302-1015-3<br />
|oclc=<br />
|doi=<br />
|bibcode=<br />
|id=<br />
|pages= 118–119<br />
|nopp=<br />
|chapter= 4<br />
|chapterurl= http://books.google.com/books?id=tdRes4IdLiIC&pg=PA118&lpg=PA118&dq=sqlplus+predefined+variable&source=bl&ots=7Qx008gycp&sig=PYHPGw7CVSsrKJwaXXLDR_ZtsLc&hl=en&ei=QcFvStL6NYPwsQOx48zNCA&sa=X&oi=book_result&ct=result&resnum=9<br />
|quote=<br />
|ref=<br />
|laysummary=<br />
|laydate=<br />
|separator= <br />
|postscript= <br />
|lastauthoramp=<br />
}}<br />
</ref><br />
** substitution variables, useful for interacting with user-input<ref><br />
{{cite web<br />
|first = Natalka<br />
|last = Roshak<br />
|authorlink = <br />
|title = Spice up your SQL Scripts with Variables<br />
|url = http://www.orafaq.com/node/515<br />
|archiveurl = <br />
|work = Oracle FAQ<br />
|publisher = <br />
|location = <br />
|doi = <br />
|date = 2005-11-06<br />
|archivedate = <br />
|accessdate = 2009-07-29<br />
|quote = & and && indicate substitution variables in SQL*Plus scripts or commands.<br />
}}<br />
</ref><br />
* bind variables, prefixed by a colon (':'), which can interact with the PL/SQL environment. Displayable with the VARIABLE and PRINT commands<ref><br />
{{cite web<br />
|first = René<br />
|last = Nyffenegger<br />
|author = <br />
|authorlink = <br />
|coauthors = <br />
|title = Using bind variables in SQL*Plus<br />
|url = http://www.adp-gmbh.ch/ora/sqlplus/use_vars.html<br />
|archiveurl = <br />
|work = René Nyffenegger's collection of things on the web<br />
|publisher = <br />
|location = <br />
|doi = <br />
|date = <br />
|month = <br />
|year = <br />
|archivedate = <br />
|accessdate = 2009-07-29<br />
|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> <br />
}}<br />
</ref><br />
<br />
== Supplementary software ==<br />
* [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.<br />
* [http://utopia.knoware.nl/~hlub/uck/rlwrap/ rlwrap] rlwrap does [[GNU]] [[Readline]] like command completion for SQL*Plus on [[UNIX]] and [[Linux]].<br />
--><br />
== Тағы қараңыз ==<br />
* [[Oracle SQL Developer]]<br />
<br />
==Сілттемелер==<br />
{{Reflist}}<br />
<br />
==Сыртқы сілттемелер==<br />
* [http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/toc.htm SQL*Plus documentation]<br />
* [http://www.orafaq.com/wiki/SQL*Plus_FAQ SQL*Plus FAQ]<br />
* [http://www.sql-plus.com/ SQL*Plus tutorial]<br />
<br />
{{DEFAULTSORT:Sql*Plus}}<br />
[[Санат:Oracle]]<br />
[[Санат:PL/SQL]]<br />
[[Санат:SQL]]<br />
[[Санат:Ақпараттану]]</div>
Нұрлан Рахымжанов