【免费】PL/SQL英文教程资源-CSDN文库

PLSQL

需积分: 0 18 浏览量 2009-05-07 16:08:49 上传评论收藏 1.27MB DOC 举报

资源详情

资源评论

资源推荐

PL/SQL Developer 4.0

User’s Guide

July 2001

Allround Automations

PL/SQL Developer 4.0 User’s Guide 3

License terms

Allround Automations vof licenses the following software to you only upon the condition that you

accept all of the terms contained in this license agreement. Please read the terms carefully before

installing this software any further, as further installing this software will indicate your assent to them.

If you do not agree to these terms, then Allround Automations is unwilling to license the software to

you, in which event you should return the full product with proof of purchase to the dealer from whom

it was acquired within fourteen days of purchase, and your money will be refunded, unless the software

package returned proofs to the conditions of Allround Automations that full installation has been made

anyway, in which case your money will not be refunded.

License and Warranty

The software that accompanies this license (the "Software") is the property of Allround Automations

vof or its licensors and is protected by copyright law. While Allround Automations continues to own the

Software, you will have certain rights to use the Software after your acceptance of this license. Except

as may be modified by a license addendum which should accompany this license if present, your rights

and obligations with respect to the use of this Software are as follows:

You may

1. Use one copy of the Software on a single computer;

2. Make one copy of the Software for archival purposes, or copy the Software onto the hard disk of

your computer and retain the original for archival purposes;

3. Use the Software on a network, provided that you have a licensed copy of the Software for each

computer that can access the Software over that network;

4. After written notice to Allround Automations vof, transfer the Software on a permanent basis to

another person or entity, provided that you retain no copies of the Software and the transferee

agrees to the terms of this agreements;

5. Sell any product developed by you using the Software for creating executable files without any

royalties to Allround Automations vof, provided that you use a licensed copy of the Software

registered on your name;

6. If a single person uses the computer on which the Software is installed at least 80% of the time,

then, provided that person uses a licensed copy of he Software, that person may also use the

Software on a single home computer.

You may not

1. Copy the documentation which accompanies the Software either in electronic or written form;

2. Sublicense, rent or lease any portion of the Software;

3. Reverse engineer, decompile, disassemble, modify, translate, make any attempt to discover the

source code of the Software, or create derivative works from the Software in any other ways as

granted in article 5 under "You may" unless you have a licensed copy of the Software also

containing the source code (which is a special license);

4. Use a previous version or copy of the Software after you have received a replacement set by email

or disk or an upgraded version as a replacement of the prior version. All copies of the prior

version must be destroyed.

PL/SQL Developer 4.0 User’s Guide 4

Disclaimer of damages

Regardless of whether any remedy set forth herein fails of its essential purpose, in no event will

Allround Automations vof be liable to you for any special, consequential, indirect or similar damages.

Including any lost profits or lost data arising out of the use or inability to use the software even if

Allround Automations vof has been advised of the possibility of such damages. Some States do not

allow the limitation or exclusion of liability for incidental or consequential damages, so the above

limitation or exclusion may not apply to you. In no case shall Allround Automations vof's liability

exceed the purchase price for the Software. The disclaimers and limitations set forth above will apply

regardless of whether you accept the Software.

General

This Agreement will be governed by the laws of The Netherlands. This Agreement may only be

modified by a license addendum that accompanies this license or by a written document that has been

signed by both you and Allround Automations vof. Should you have any questions concerning this

Agreement, or if you desire to contact Allround Automations vof for any reason, please write: Allround

Automations vof, Holskottelanden 4, 7542KN Enschede, The Netherlands or send us your questions or

remarks by email: sales@allroundautomations.nl

The software described in this book is furnished under a license agreement and may be used only in

accordance with the terms of the agreement.

No part of this publication may be copied without the express written permission of Allround

Automations vof, Holskottelanden 4, 7542KN Enschede, The Netherlands

Trademarks

Allround Automations, PL/SQL Developer are trademarks of Allround Automations vof, Enschede, The

Netherlands. Other product names mentioned in this manual or in the Software may be trademarks or

registered trademarks of their respective companies and are hereby acknowledged.

PL/SQL Developer 4.0 User’s Guide 5
Contents
 LICENSE TERMS...................................................................................................................................3
 CONTENTS..............................................................................................................................................5
1.  INTRODUCTION................................................................................................................................7
2.  INSTALLATION...............................................................................................................................10
SYSTEM REQUIREMENTS........................................................................................................................10
WORKSTATION INSTALLATION..............................................................................................................10
SERVER INSTALLATION..........................................................................................................................10
UNINSTALLING PL/SQL DEVELOPER....................................................................................................10
3.  WRITING PROGRAMS...................................................................................................................11
CREATING A PROGRAM..........................................................................................................................11
SAVING A PROGRAM..............................................................................................................................12
MODIFYING A PROGRAM........................................................................................................................13
COMPILING A PROGRAM........................................................................................................................13
4.  TESTING PROGRAMS....................................................................................................................15
CREATING A TEST SCRIPT.....................................................................................................................15
EXECUTING A TEST SCRIPT...................................................................................................................16
VARIABLES TYPES.................................................................................................................................17
SAVING TEST SCRIPTS...........................................................................................................................17
TRACKING RUN-TIME ERRORS...............................................................................................................18
PACKAGE STATES & JAVA SESSION STATES..........................................................................................18
VIEWING RESULT SETS...........................................................................................................................18
VIEWING DBMS_OUTPUT.......................................................................................................................19
DEBUGGING...........................................................................................................................................19
5.  OPTIMIZING....................................................................................................................................23
USING THE EXPLAIN PLAN WINDOW....................................................................................................23
ANALYZING SQL IN A PROGRAM UNIT..................................................................................................24
AUTOMATIC STATISTICS........................................................................................................................24
THE PL/SQL PROFILER.........................................................................................................................25
SQL TRACE...........................................................................................................................................26
6.  AD HOC SQL.....................................................................................................................................28
USING THE SQL WINDOW.....................................................................................................................28
RESULT GRID MANIPULATION................................................................................................................29
QUERY BY EXAMPLE MODE..................................................................................................................31
UPDATING THE DATABASE.....................................................................................................................32
SAVING SQL SCRIPTS............................................................................................................................32
SAVING QUERY RESULTS.......................................................................................................................33
7.  THE COMMAND WINDOW...........................................................................................................34
ENTERING SQL STATEMENTS AND COMMANDS....................................................................................34
DEVELOPING COMMAND FILES..............................................................................................................35
SUPPORTED COMMANDS........................................................................................................................36
8.  CREATING AND MODIFYING NON-PL/SQL OBJECTS.........................................................38
THE TABLE DEFINITION EDITOR.............................................................................................................38
THE SEQUENCE DEFINITION EDITOR......................................................................................................48
THE SYNONYM DEFINITION EDITOR.......................................................................................................48
THE LIBRARY DEFINITION EDITOR.........................................................................................................49
THE DIRECTORY DEFINITION EDITOR.....................................................................................................49