SQL Plus: Difference between revisions

Revision as of 15:52, 19 November 2023

Latest revision as of 06:51, 15 August 2025

(10 intermediate revisions by 6 users not shown)

Line 43:

==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 178:

while running a subsequent SQL Plus command.

=== Installation and Configurationconfiguration ===

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>

=== Script Execution ===

SQL''Plus can execute SQL scripts stored in files. This is often used for batch processing or automating database tasks. You can run scripts by passing the script name as an argument to SQL''Plus or by using the <code>START</code> or <code>@</code> command within SQL*Plus.

=== Command Line Usage ===

SQL*Plus is commonly used in command-line environments. It can be integrated into shell scripts or automated tasks to perform database operations.

=== Integration with Applications ===

In some cases, applications might need to interact with Oracle databases via SQL''Plus. This can be done by invoking SQL''Plus from the application, typically through system calls or command-line interfaces.

== 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==