Plsql
plsql
#plsql
Table of Contents
About
1
Chapter 1: Getting started with plsql
2
Remarks
2
Examples
2
Definition of PLSQL
2
Hello World
3
About PLSQL
3
Difference between %TYPE and %ROWTYPE.
4
Create or replace a view
4
Create a table
5
Chapter 2: Assignments model and language
Examples
Assignments model in PL/SQL
Chapter 3: Bulk collect
Examples
Bulk data Processing
Chapter 4: Collections and Records
Examples
Use a collection as a return type for a split function
Chapter 5: Cursors
6
6
6
8
8
8
9
9
9
10
Syntax
10
Remarks
10
Examples
10
Parameterized "FOR loop" Cursor
10
Implicit "FOR loop" cursor
10
Working with SYS_REFCURSOR
11
function returning a cursor
11
and how to use it:
11
Handling a CURSOR
Chapter 6: Exception Handling
12
13
Introduction
13
Examples
13
Exception handling
13
Syntax
13
Internally defined exceptions
14
Predefined exceptions
15
User defined exceptions
16
Define custom exception, raise it and see where it comes from
16
Handling connexion error exceptions
18
Chapter 7: Exception Handling
19
Introduction
19
Examples
19
Handling connexion error exceptions
19
Define custom exception, raise it and see where it comes from
20
Chapter 8: Functions
22
Syntax
22
Examples
22
Generate GUID
22
Calling Functions
22
Chapter 9: IF-THEN-ELSE Statement
24
Syntax
24
Examples
24
IF-THEN
24
IF-THEN-ELSE
24
IF-THEN-ELSIF-ELSE
25
Chapter 10: Loop
26
Syntax
26
Examples
26
Simple Loop
26
WHILE Loop
26
FOR Loop
27
Chapter 11: Object Types
29
Remarks
29
Examples
29
BASE_TYPE
29
MID_TYPE
30
LEAF_TYPE
31
Accessing stored objects
32
Chapter 12: Packages
34
Syntax
34
Examples
35
Package Usage
36
Overloading
36
Restrictions on Overloading
Define a Package header and body with a function.
Chapter 13: PLSQL procedure
37
37
39
Introduction
39
Examples
39
Syntax
39
Hello World
39
In/Out Parameters
40
Chapter 14: Triggers
41
Introduction
41
Syntax
41
Examples
41
Before INSERT or UPDATE trigger
Credits
41
43
About
You can share this PDF with anyone you feel could benefit from it, downloaded the latest version
from: plsql
It is an unofficial and free plsql ebook created for educational purposes. All the content is extracted
from Stack Overflow Documentation, which is written by many hardworking individuals at Stack
Overflow. It is neither affiliated with Stack Overflow nor official plsql.
The content is released under Creative Commons BY-SA, and the list of contributors to each
chapter are provided in the credits section at the end of this book. Images may be copyright of
their respective owners unless otherwise specified. All trademarks and registered trademarks are
the property of their respective company owners.
Use the content presented in this book at your own risk; it is not guaranteed to be correct nor
accurate, please send your feedback and corrections to info@
1
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.