O'Reilly logo

Oracle SQL*Plus Pocket Reference, 3rd Edition by Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL*Plus Command Reference

This section contains an alphabetic listing of all the SQL*Plus commands, with brief descriptions.

Comment Delimiters (/*...*/)

/*
comment_text
comment_text
comment_text
*/

The /* and */ delimiters set off a comment in SQL*Plus. Comments entered this way may span multiple lines. If you use /*...*/ in a script file, the comments are displayed on the screen when the script is executed. For example:

/* SQL*Plus script written 7-Jan-2000
   by Jonathan Gennick. */

Double Hyphen ( -- )

-- comment_text

The double hyphen can place a single-line comment in a SQL*Plus script. For example:

--Written 7-Jan-2000 by Jonathan Gennick

At Sign (@)

@{url|file} [argument [argument...]]

The at sign (@) executes a SQL*Plus script file. For example:

@$ORACLE_HOME/rdbms/admin/utlxplan
@http://Gennick.com/message.sql 2

In Oracle9i Database Release 1, only the Windows version of SQL*Plus allows you to identify a script file by its URL. In Oracle9i Database Release 2 and higher, all versions of SQL*Plus support this functionality. URLs may be HTTP or FTP.

In iSQL*Plus, you must specify a URL with the @ command; you cannot specify a filename.

Double At Sign (@@)

@{url | file} [argument [argument...]]

The double at sign (@@) is used within a script file to execute another script file from the same directory as the first. For example:

@@generate_emp_report
@@generate_pay_history_report '101'

In iSQL*Plus, you must specify a URL with the @@ command; you cannot specify a filename.

Forward Slash (/)

/

A forward ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required