Oracle PLSQL Language- P1

The Oracle PL / SQL Ngôn ngữ Pocket tham khảo là một hướng dẫn tham khảo nhanh đến các PL / SQLngôn ngữ lập trình, cung cấp các phần mở rộng thủ tục để các cơ sở dữ liệu quan hệ SQLngôn ngữ và một loạt các công cụ phát triển Oracle.
Nội dung trích xuất từ tài liệu:
Oracle PLSQL Language- P1Please purchase PDF Split-Merge on www.verypdf.com to By Steven Feuerstein, Bill Pribyl & Chip Dawes; ISBN 1-56592-457-6E First Edition, published 1999-04-01. (See the catalog page for this book.) Search the text of Oracle PL/SQL Language Pocket Reference. Table of Contents Chapter 1: Oracle PL/SQL Language Pocket Reference 1.1: Introduction 1.2: Acknowledgments 1.3: Conventions 1.4: PL/SQL Language Fundamentals 1.5: Variables and Program Data 1.6: Conditional and Sequential Control 1.7: Loops 1.8: Database Interaction and Cursors 1.9: Cursors in PL/SQL 1.10: Exception Handling 1.11: Records in PL/SQL 1.12: Named Program Units 1.13: Triggers 1.14: Packages 1.15: Calling PL/SQL Functions in SQL 1.16: Oracle8 Objects 1.17: Collections 1.18: External Procedures 1.19: Java Language Integration The Oracle PL/SQL CD Bookshelf Navigation Copyright © 2000 OReilly & Associates. All Rights Reserved.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Full Text Search If you are having difficulty searching, or if you have not used this search utility before, please read this. The Oracle PL/SQL CD Bookshelf NavigationPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Chapter 1 Next: 1.2 Acknowledgments 1. Oracle PL/SQL Language Pocket Reference Contents: Introduction Acknowledgments Conventions PL/SQL Language Fundamentals Variables and Program Data Conditional and Sequential Control Loops Database Interaction and Cursors Cursors in PL/SQL Exception Handling Records in PL/SQL Named Program Units Triggers Packages Calling PL/SQL Functions in SQL Oracle8 Objects Collections External Procedures Java Language Integration 1.1 Introduction The Oracle PL/SQL Language Pocket Reference is a quick reference guide to the PL/SQL programming language, which provides procedural extensions to the SQL relational database language and a range of Oracle development tools. Where a package, program, or function is supported only for a particular version of Oracle (e.g., Oracle8i), we indicate this in the text.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. The purpose of this pocket reference is to help PL/SQL users find the syntax of specific language elements. It is not a self-contained user guide; basic knowledge of the PL/SQL programming language is required. For more information, see the following books: Oracle PL/SQL Programming, 2nd Edition, by Steven Feuerstein with Bill Pribyl (OReilly & Associates, 1997). Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (OReilly & Associates, 1998). Oracle PL/SQL Built-ins Pocket Reference, by Steven Feuerstein, John Beresniewicz, and Chip Dawes (OReilly & Associates, 1998). Oracle PL/SQL Language Next: 1.2 Pocket Reference Acknowledgments 1.2 Acknowledgments The Oracle Library Navigation Copyright (c) 2000 OReilly & Associates. All rights reserved.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Previous: 1.1 Introduction Chapter 1 Next: 1.3 Conventions Oracle PL/SQL Language Pocket Reference 1.2 Acknowledgments We would like to thank our reviewers: Eric J. Givler, Department of Environmental Protection, Harrisburg, Pennsylvania; and Stephen Nelson, HK Systems, New Berlin, Wisconsin. Previous: 1.1 Introduction Oracle PL/SQL Language Next: 1.3 Conventions Pocket Reference 1.1 Introduction 1.3 Conventions The Oracle Library Navigation Copyright (c) 2000 OReilly & Associates. All rights reserved.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Previous: 1.2 Chapter 1 Next: 1.4 PL/SQL Acknowledgments Oracle PL/SQL Language Language Fundamentals Pocket Reference 1.3 Conventions UPPERCASE indicates PL/SQL keywords. lowercase indicates user-defined items such as parameters. Italic indicates file names and parameters within text. Constant width is used for code examples. [] enclose optional items in syntax descriptions. { } enclose a list of items in syntax descriptions; you must choose one item from the list. | separates bracketed list items in syntax descriptions. Previous: 1.2 Oracle PL/SQL Language Next: 1.4 PL/SQL Acknowledgments Pocket Reference Language Fundamentals 1.2 Acknowledgments 1.4 PL/SQL Language Fundamentals The Oracle Library Navigation Copyright (c) 2000 OReilly & Associates. All rights reserved.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Previous: 1.3 Conventions Chapter 1 Next: 1.5 Variables and Oracle PL/SQL Language Program Data Pocket Reference 1.4 PL/SQL Language Fundamentals 1.4.1 The PL/SQL Character Set The PL/SQL language is constructed from letters, digits, symbols, and whitespace, as defi ...