Mastering PL/SQL Through Illustrations

Name: Mastering PL/SQL Through Illustrations | From Learning Fundamentals to Developing Efficient PL/SQL Blocks (English Edition)
Brand: De Gruyter
Price: 14.49 EUR
Availability: OnlineOnly

From Learning Fundamentals to Developing Efficient PL/SQL Blocks (English Edition)

B. Chandra(Autor*in)

De Gruyter (Verlag)

1. Auflage

Erschienen am 29. September 2020

288 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-93-89898-49-1 (ISBN)

14,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Title Page
Copyright Page
Dedication Page
About the Author
About the Reviewer
Acknowledgement
Preface
Errata
Table of Contents
1. Introduction to PL/SQL
List of topics
Objective
1.1 PL/SQL block
1.2 Comments in PL/SQL
1.3 DBMS_OUTPUT statement for online display
1.4 Variable declarations in PL/SQL
1.5 Data types in PL/SQL
1.5.1 Numeric data type
1.5.1.1 Number
1.5.1.2 Number subtypes
1.5.2 Character datatypes
1.5.2.1 CHAR
1.5.2.2 VARCHAR
1.5.2.3 VARCHAR2
1.5.3 DATE data type
1.5.4 BOOLEAN data type
1.6 RAW, LONG RAW and LOB datatypes
1.6.1 RAW and LONG RAW data type
1.6.2 LOB data type
1.7 Execution of PL/SQL blocks on Oracle APEX
1.8 Illustrative PL/SQL blocks
1.9 PL/SQL constants
1.10 Conversion from character to number and number to character
1.11 Scope of variables in PL/SQL
1.12 PL/SQL records
1.13 Retrieving data from a database table and storing it in a record using SELECT INTO statement
1.14 %TYPE
1.15 %ROWTYPE
Conclusion
Questions
2. PL/SQL Control Structures
Introduction
List of topics
Objective
2.1 IF-THEN-ELSE
2.2 CASE statement in PL/SQL
2.3 Searched CASE statement
2.4 GOTO statement
2.5 Illustrative codes using database tables
Conclusion
Questions
3. Loops in PL/SQL
Introduction
List of topics
Objective
3.1 Simple Loops
3.2 WHILE loop
3.3 CONTINUE statement
3.4 Numeric FOR loop
3.5 Illustrative codes using database tables
Conclusion
Questions
4. Cursors in PL/SQL
Introduction
List of topics
Objective
4.1 Types of cursors
4.2 Processing of explicit cursors
4.3. Illustrations for the use of explicit cursors using database tables
4.4 Cursor attributes
4.5 Illustrations of cursor attributes using different database tables
4.6 Implicit cursors
4.7 REF cursor
4.8 Cursor for loops
4.9 Codes illustrating cursor for loop using database tables
Conclusion
Questions
5. Exceptions in PL/SQL
Introduction
List of topics
Objective
5.1 Exceptions and exception handlers
5.2 User-defined exceptions
5.3 Raising exceptions (user-defined)
5.4 Exception section
5.5 Illustrations of user-defined exceptions using database tables
5.6 Predefined exceptions
5.7 SQLCODE and SQLERRM
5.8 RAISE_APPLICATION_ERROR
5.9 PRAGMA EXCEPTION_INIT
5.10 Raising different exceptions in a PL/SQL block
5.11 Reraising Exceptions and Exception raised in Exception
Conclusion
Questions
6. Procedures in PL/SQL
Introduction
List of topics
Objective
6.1 Subprograms
6.2 Advantages of subprograms
6.3 Syntax of a procedure
6.4 Formal and actual parameters
6.5 Parameter modes
6.6 Illustrative PL/SQL procedures using database tables
6.7 Invoking a procedure
6.8 Types of calling notations
6.8.1 Positional calling notation
6.8.2 Named calling notations
6.8.3 Mixed notation
6.9 Illustrative procedures and calling blocks for the three calling notations
6.10 More illustrations of procedures using database tables
Conclusion
Questions
7. Functions in PL/SQL
Introduction
List of topics
Objective
7.1 Functions
7.2 Parameter modes
7.3 Illustrations of functions using database tables
7.4 Calling/invoking a function
7.5 Calling notations: Positional, named, and mixed notation
7.6 More illustrations of the creation of functions and invoking blocks using database tables
Conclusion
Questions
8. PL/SQL Triggers
Introduction
List of topics
Objective
8.1 Database trigger
8.2 Creation of triggers using database tables
Conclusion
Questions
9. Packages
List of topics
Objective
9.1 Packages
9.2 Illustration of creation of packages, package body and execution using database tables
9.3 Calling packaged subprograms
9.4 Additional illustrations of the creation of packages and package body and execution
Conclusion
Questions
10. PL/SQL Collections
Introduction
List of topics
Objective
10.1 Types of collections
10.2 Categorization of collections
10.3 INDEX-BY table or Associative array
10.4 Illustrative codes for creating INDEX-BY TABLE
10.4.1 Methods in collection for retrieving the value of index or subscript
10.4.2 Methods in collection for deleting elements
10.5 Nested Table
10.6 Illustrative codes on nested table
10.6.1 Methods in collection useful for nested table
10.7 Variable size array or Varray
10.8 Illustrative codes on varray
10.9 INDEX-BY TABLE of NESTED TABLE
10.10 INDEX-BY TABLE of INDEX-BY TABLE
10.11 Creating NESTED TABLE and INDEX-BY TABLE from a database table
Conclusion
Questions
Appendix I
Steps for requesting a workspace and Executing PL/SQL blocks on Oracle APEX (Application Express)
Appendix II
Description and data of all databases used
FLIGHT1 database
INSTITUTE database
Appendix III
Creation of tables in databases and sample insertion of data

Systemvoraussetzungen

Als PDF speichern Als Link merken