没有合适的资源？快使用搜索试试~ 我知道了~

首页Oracle SQL*Plus Pocket Reference, 2nd Edition

Oracle SQL*Plus Pocket Reference, 2nd Edition

oracle

sql

需积分: 10 15 下载量 81 浏览量更新于2023-03-16 评论 1 收藏 828KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

56页

Oracle SQL*Plus Pocket Reference, 2nd Edition Copyright Oracle SQL*PlusPocket Reference Section 1.1. Introduction Section 1.2. Interacting with SQL*Plus Section 1.3. Selecting Data Section 1.4. Inserting Data Section 1.5. Updating Data Section 1.6. Deleting Data Section 1.7. Merging Data (Oracle9i) Section 1.8. Transaction Management Section 1.9. Formatting Text Reports Section 1.10. Tuning SQL Section 1.11. SQL*Plus Format Elements

资源详情

资源评论

资源推荐

•

Tabl e o f

Contents

• Index

• Reviews

•

Reader

Reviews

• Errata

Oracle SQL*Plus Pocket Reference, 2nd Edition

By Jonathan Gennick

Publisher : O'Reilly

Pub Date : October 2002

ISBN : 0-596-00441-9

Pages : 120

Oracle SQL*PlusPocket Reference

Section 1.1. Introduction

Section 1.2. Interacting with SQL*Plus

Section 1.3. Selecting Data

Section 1.4. Inserting Data

Section 1.5. Updating Data

Section 1.6. Deleting Data

Section 1.7. Merging Data (Oracle9i)

Section 1.8. Transaction Management

Section 1.9. Formatting Text Reports

Section 1.10. Tuning SQL

Section 1.11. SQL*Plus Format Elements

Oracle SQL*PlusPocket Reference

Section 1.1. Introduction

Section 1.2. Interacting with SQL*Plus

Section 1.3. Selecting Data

Section 1.4. Inserting Data

Section 1.5. Updating Data

Section 1.6. Deleting Data

Section 1.7. Merging Data (Oracle9i)

Section 1.8. Transaction Management

Section 1.9. Formatting Text Reports

Section 1.10. Tuning SQL

Section 1.11. SQL*Plus Format Elements

1.1 Introduction

The Oracle SQL*Plus Pocket Reference is a quick-reference guide to SQL*Plus and to commonly

used SQL query and data manipulation statements. The purpose of this book is to help you find the

syntax of specific language elements. It is not a self-contained user guide; basic knowledge of

SQL*Plus is assumed. For more information, see my book Oracle SQL*Plus: The Definitive Guide

(O'Reilly) and Mastering Oracle SQL by Sanjay Mishra and Alan Beaulieu (O'Reilly).

1.1.1 Acknowledgments

Deborah Russell, Darl Kuhn, Ken Jacobs, and Alison Holloway all played a part in making this book

a reality. For their assistance and support, I'm most grateful.

1.1.2 Conventions

UPPERCASE

Indicates SQL*Plus, SQL, or PL/SQL keywords

lowercase

Indicates user-defined items such as table names

Italic

Indicates filenames, emphasis, introduction of new terms, and parameter names

Constant width

Used for code examples

Constant width bold

Indicates user input in examples showing an interaction

[ ]

Used in syntax descriptions to denote optional elements

{ }

Used in syntax descriptions to denote a required choice

Used in syntax descriptions to separate choices

Used in syntax descriptions to indicate that the underlined option is the default

1.2 Interacting with SQL*Plus

This section covers essential information you need to know to interact with SQL*Plus. Here you will

learn how to start SQL*Plus, enter commands, delimit strings, and name variables.

1.2.1 Starting SQL*Plus

Invoke SQL*Plus by issuing the sqlplus command from your operating-system command prompt.

On Microsoft Windows systems, use either sqlplus or sqlplusw depending on whether you want

SQL*Plus to run in a command-prompt window or in its own window; you can also select an icon

from the Start menu. (Early releases of SQL*Plus on Windows used executable names such as

PLUS33 and PLUS80W.)

Beware of passing your password as a command-line argument to

SQL*Plus. Such passwords may be easily visible to other users on Linux

and Unix systems.

1.2.1.1 Syntax for the sqlplus command

The syntax used to invoke SQL*Plus is as follows:

sqlplus [[-S[ILENT]] [-H[ELP]] [-V[ERSION]]

[-R[ESTRICT] level] [-L[OGON]]

[-M[ARKUP] "markup_options"]

[ [username[/password][@connect]|/

[AS {SYSDBA|SYSOPER}]]

|/NOLOG]

[@scriptfile [arg1 arg2 arg3...]]]

The -RESTRICT and -MARKUP parameters are new in Oracle8i. -HELP and -VERSION are new

in Oracle9i. Here are the parameter descriptions:

-S[ILENT]

Tells SQL*Plus to run in silent mode. No startup message is displayed; no command

prompt is displayed; no commands are echoed to the screen.

-H[ELP]

Causes SQL*Plus to display a short summary of this syntax. Prior to Oracle9i, use sqlplus -

to get the help summary.

-V[ERSION]

Causes SQL*Plus to display version and copyright information. Prior to Oracle9i, use

sqlplus -? to get version and copyright information.

-R[ESTRICT] level

Restricts what the user can do from SQL*Plus. The level must be one of the following:

Disables the EDIT, HOST, and ! commands

Disables the EDIT, HOST, !, SAVE, SPOOL, and STORE commands

Disables the EDIT, GET, HOST, !, SAVE, START, @, @@, SPOOL, and STORE

commands

Level 3 also disables the reading of the login.sql file. The glogin.sql file is read, but

restricted commands aren't executed.

-L[OGON] (new in Oracle9i Release 9.2)

Prevents SQL*Plus from reprompting for the username and password in the event that the

first username and password passed is incorrect.

-M[ARKUP] markup_options

Allows you to specify the markup language to use when generating output. Except for

HTML, all markup options are optional. The following are valid markup options. Default

values are underlined or noted in the text.

HTML {ON | OFF}

Specifies the markup language to use and enables or disables the use of that markup

language. You must specify a value for this option.

HEAD text

Specifies content for the <head> tag. The tag is written as <head>text</head>.

BODY text

Specifies attributes for the <body> tag. The tag is written as <body text>.

TABLE text

Specifies attributes for the <table> tag that formats query output. The tag is written as

<table text>.

ENTMAP {ON | OFF}

Controls whether SQL*Plus uses HTML equivalents such as < and > for special

characters such as "<" and ">".

SPOOL {ON | OFF}

Controls whether SQL*Plus writes <html>, <head>, and <body> tags to any spool file you

create during your SQL*Plus session, while HTML is ON.

PRE[FORMAT] {ON | OFF}

Controls whether query output is enclosed within <pre> ... </pre> tags rather than within

HTML tables.

On some operating systems, you need to enclose the entire string of markup options within

double quotes. For example:

sqlplus -m "html on spool off"

Furthermore, any HEAD, BODY, and TABLE text should itself be quoted, and you must

escape the quotes:

sqlplus -m "html on table \"width=50% align='left'\""

The backslash-quote (\") syntax works on Windows XP, Linux, and Unix, and places a

quote (

") within the string that is the value for the -M option.

username [/password][@connect]

Your database login information. connect is an Oracle Net connect identifier such as those

defined in $ORACLE_HOME/network/admin/tnsnames.ora.

剩余55页未读，继续阅读

Oracle PL_SQL Language Pocket Reference, 5th Edition.2015.pdf

SQL*Plus Quick Reference Release 9.2

SQL*Plus Quick Reference Release 9.2 (oracle 9202)

SQL*Plus Quick Reference Release 8.1.7

在Oracle数据库中，可以使用SQLPlus命令行工具来执行SQL语句并将结果输出到文件中。可以编写一个shell脚本来调用SQLPlus命令行工具，并将结果输出到.dat文件中。请给出一个示例脚本

脚本中使用了 `SET` 命令来设置SQL*Plus输出的格式，以便将结果输出到文件中。在执行SQL查询语句时，使用 `SPOOL` 命令将结果输出到 `output.dat` 文件中。最后，使用 `EXIT` 命令退出 SQL*Plus。你可以将脚本保存...

使用oracle，请以sys管理员登录，利用SQLPlus，创建stu211543217用户，密码为stu 211543217，创建并默认表空间为stu_tbs，同时该用户处于锁状态。然后利用SQLPlus，从DBA_USERS数据字典中查看stu211543217用户的默认表空间和临时表空间的信息。然后利用SQLPlus，修改stu211543217用户，将该用户解锁，并将密码改为“123456”。然后利用SQLPlus，授予stu211543217用户“CREATE ANY TABLE”、“CREATE ANY INDEX”、“ALTER ANY TABLE”、“ALTER ANY INDEX”、“DROP ANY TABLE”和“DROP ANY INDEX”系统权限。然后利用SQL*Plus，将stu211543217用户授予HR模式中对departments表的查看、修改、删除对象权限；对hr模式下employees表的全部权限。然后收回stu211543217用户对hr模式中对departments表的修改、删除对象权限。然后收回stu211543217用户的“DROP ANY TABLE” 和“DROP ANY INDEX”系统权限。

好的，以下是您需要的SQL语句: 1. 创建stu211543217用户，密码为stu211543217，创建并默认表空间为stu_tbs，同时该用户处于锁状态: ``` CREATE USER stu211543217 IDENTIFIED BY stu211543217 DEFAULT TABLESPACE ...

Windows中怎么进入Oracle数据库

在Windows中进入Oracle数据库，可以通过Oracle SQL*Plus命令行工具或Oracle SQL Developer图形界面工具进行操作。以下是两种方法的简要说明： 1. 使用Oracle SQL*Plus命令行工具： - 打开命令提示符：按下Windows...

SQL*Plus 中确认该表是否真正地被删除。

您可以通过以下步骤在 SQL*Plus 中确认表是否被删除： 1. 连接到 Oracle 数据库，可以在终端中输入以下命令： ``` sqlplus username/password@hostname:port/service_name ``` 其中，username 是您的数据库...

Linux关闭Oracle库命令

关闭Oracle库的命令可以使用SQL*Plus或者SQL Developer进行，具体步骤如下： 1. 连接到Oracle数据库：使用SQL*Plus连接数据库的命令为： ``` sqlplus / as sysdba ``` 如果你使用的是SQL Developer，直接打开...

oracle用*号打印正金子塔

以下是 Oracle SQL 打印正金字塔的示例代码： ``` SET SERVEROUTPUT ON;...你可以将 `n` 的值改为你想要的层数，然后执行这段代码即可在 Oracle SQL Developer 或 SQL*Plus 等工具中打印出正金字塔。

oracle 怎么进入sqlplus

要进入 SQL*Plus，需要首先打开命令行终端或控制台。然后按以下步骤操作： 1. 输入以下命令启动 SQL*Plus： ``` sqlplus ``` 2. 提示输入账号和密码时，输入你的用户名和密码（如果使用默认用户名和密码，可以...

xinxin19881112

粉丝: 644
资源: 257

上传资源快速赚钱

我的内容管理收起

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

会员权益专享

Oracle SQL*Plus Pocket Reference, 2nd Edition

评论0

会员权益专享

最新资源

Oracle SQL*Plus Pocket Reference, 2nd Edition

评论0

Oracle PL_SQL Language Pocket Reference, 5th Edition.2015.pdf

SQL*Plus Quick Reference Release 9.2

SQL*Plus Quick Reference Release 8.1.7

在Oracle数据库中，可以使用SQL*Plus命令行工具来执行SQL语句并将结果输出到文件中。可以编写一个shell脚本来调用SQL*Plus命令行工具，并将结果输出到.dat文件中。 请给出一个示例脚本

怎样用spfile文件启动数据库使用sql*plus语言，即startup spfile

oracle sqlplus

Oracle如何执行.sql文件

oracle sql developer中怎么使用show命令

ORACLE官方文档中怎么解释的sqlplus

oracle11g安装完成后能直接食用sql语句吗

sql plus安装包

SQL*Plus break与compute的简单用法

/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/

怎样使用sqlplus

Windows中怎么进入Oracle数据库

SQL*Plus 中确认该表是否真正地被删除。

Linux关闭Oracle库命令

oracle用*号打印正金子塔

oracle 怎么进入sqlplus

会员权益专享

最新资源

在Oracle数据库中，可以使用SQLPlus命令行工具来执行SQL语句并将结果输出到文件中。可以编写一个shell脚本来调用SQLPlus命令行工具，并将结果输出到.dat文件中。请给出一个示例脚本