没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
SQL*Plus
Quick Reference
Release 9.2
March 2002
Part No. A90843-01
About this Quick Reference
This Quick Reference shows iSQL*Plus buttons and icons, and iSQL*Plus
and SQL*Plus command syntax. For detailed information on each
command, refer to the SQL*Plus User’s Guide and Reference.
This Quick Reference has the following topics:
■ Conventions for Command Syntax
■ Documentation Accessibility
■ Starting iSQL*Plus
■ Running the iSQL*Plus Server Statistics Report
■ iSQL*Plus Navigation
■ iSQL*Plus Preferences
■ iSQL*Plus Work Screen Buttons
■ Starting and Leaving SQL*Plus
■ Starting Up and Shutting Down a Database
■ Entering and Executing Commands
■ Manipulating SQL, SQL*Plus and PL/SQL Commands
■ Formatting Query Results
■ Accessing Databases
■ Miscellaneous
Oracle is a registered trademark, and Oracle9
i
, SQL*Plus and
i
SQL*Plus are trademarks or registered trademarks of Oracle
Corporation. Other names may be trademarks of their respective owners.
Copyright 1996, 2002 Oracle Corporation.
All Rights Reserved.
2
Conventions for Command Syntax
The following two tables describe the notation and conventions for
command syntax used in this Quick Reference.
Commands, Terms, and Clauses
Punctuation
Feature Example Explanation
uppercase BTITLE Enter text exactly as spelled; it need not be in
uppercase.
lowercase italics column A clause value; substitute an appropriate value.
words with
specific meanings
c A single character.
char A CHAR value—a literal in single quotes—or an
expression with a CHAR value.
d or e A date or an expression with a DATE value.
expr An unspecified expression.
m or n A number of an expression with a NUMBER
value.
text A CHAR constant with or without single quotes.
variable A user variable (unless the text specifies another
variable type).
Feature Example Explanation
vertical bar | Separates alternative syntax elements that may be
optional or mandatory.
brackets [ON|OFF] One or more optional items. If two items appear
separated by |, enter one of the items. Do not enter
the brackets or |.
braces {ON|OFF} A choice of mandatory items; enter one of the items.
Do not enter the braces or |.
underlining{ON|OFF
} A default value; if you enter nothing, SQL*Plus
assumes the underlined value.
ellipsis n ... Preceding items may be repeated any number of
times.
3
Documentation Accessibility
Our goal is to make Oracle products, services, and supporting
documentation accessible, with good usability, to the disabled community.
To that end, our documentation includes features that make information
available to users of z technology. This documentation is available in HTML
format, and contains markup to facilitate access by the disabled community.
Standards will continue to evolve over time, and Oracle Corporation is
actively engaged with other market-leading technology vendors to address
technical obstacles so that our documentation can be accessible to all of our
customers. For additional information, visit the Oracle Accessibility
Program Web site at http://www.oracle.com/accessibility/
4
Starting iSQL*Plus
Use the following syntax in your web browser’s URL field to display
iSQL*Plus.
http://machine_name.domain:port/isqlplus[?UserOpts]
or to start iSQL*Plus with DBA privileges, use:
http://machine_name.domain/isqlplusdba[?DBAOpts]
where UserOpts has the following syntax:
UserLogin|Script|UserLogin&Script
where DBAOpts has the following syntax:
DBALogin|Script|DBALogin&Script
where UserLogin has the following syntax:
userid=username[/password][@connect_identifier]
where DBALogin has the following syntax:
userid={username[/password][@connect_identifier] | / } AS {SYSDBA | SYSOPER}
and where Script has the following syntax:
script=text[&type={url|text}] [&action={execute|load}] [&variable=value. . .]
Examples:
To start iSQL*Plus, enter
http://machine_name.domain:port/isqlplus
To start iSQL*Plus with DBA Privileges, enter
http://machine_name.domain:port/isqlplusdba
Running the iSQL*Plus Server Statistics Report
Use the following syntax in your web browser for the iSQL*Plus Server
Statistics Report URL.
http://machine_name.domain:port/isqlplusdba?statistics={active|full} [&refresh=number]
5
iSQL*Plus Navigation
The table lists navigation icons used to navigate in iSQL*Plus.
iSQL*Plus Preferences
The table lists preferences that can be set in iSQL*Plus.
iSQL*Plus Work Screen Buttons
The table lists buttons in the iSQL*Plus Work screen, and their purpose.
Icon Purpose
Logout
Log out of the iSQL*Plus session, return to the Login screen.
New Session
Start a new iSQL*Plus session in a separate browser window.
History
Open the iSQL*Plus History screen to select previously
executed scripts to reload or to delete from History.
Preferences
Open the iSQL*Plus Preferences screen to set interface
options, system variables or change your password.
Help
Open the iSQL*Plus Help in a new browser window.
Next
Go to the next page in iSQL*Plus Help.
Previous
Go to the previous page in iSQL*Plus Help.
Contents
Go to the contents in iSQL*Plus Help.
Index
Go to the index in iSQL*Plus Help.
Navigation Path Purpose
Work >
Preferences >
Set interface options
To change the size of the Input area.
To change where output is directed.
To change the number of scripts kept in the history list.
Work >
Preferences >
Set system variables
To view current system variable settings.
To set or change system variables used by iSQL*Plus.
Work >
Preferences >
Change your password
To change your Oracle9i database password.
Button Purpose
Browse... To find a local script to load into the Input area.
Load Script To load a local script into the Input area.
Execute To run the contents of the Input area.
Save Script To save the contents of the Input area to a local file.
Clear Screen To clear the Input and Output areas.
Cancel To interrupt a running script.
剩余23页未读,继续阅读
资源评论
rocazj
- 粉丝: 8
- 资源: 726
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功