Skip to content

Commit ba020a8

Browse files
committed
Demo Documetation Updates
1 parent de58707 commit ba020a8

2 files changed

Lines changed: 23 additions & 10 deletions

File tree

docs/demo/Trigger-Test.md

Lines changed: 10 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -4,13 +4,19 @@
44

55
---
66

7-
## Table and View Triggers
7+
## Triggers
88

9-
What types and kinds?
9+
The "Database PL/SQL Language Reference" (11.2) groups triggers this way:
10+
* Simple DML Trigger
11+
* Compound DML Trigger
12+
* Instead of DML Trigger
13+
* System Trigger
1014

11-
Other than tables?
15+
All of these triggers are testable with wtPLSQL?
1216

13-
## Test a Table Trigger
17+
For brevity, the simple DML trigger will be used in these examples.
18+
19+
## Test a Table Insert Trigger
1420

1521
Create a Table and Trigger.
1622

docs/demo/Type-Test.md

Lines changed: 13 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -4,13 +4,20 @@
44

55
---
66

7-
## PL/SQL Types
7+
## Oracle Database Types
88

9-
Following are the 4 Oracle Types. For the purposes of wtPLSQL Examples, only Object Types will be tested, specifically type methods.
10-
* Collection of Attributes
11-
* VArray Collection
12-
* Nested Table Collection
13-
* Object
9+
Following are the 4 Oracle database types that are defined and stored in the database.
10+
* Abstract Data Type (ADT) (including a SQLJ object type)
11+
* Standalone varying array (varray) type
12+
* Standalone nested table type
13+
* Incomplete object type
14+
15+
https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_type.htm
16+
17+
In contrast these Oracle database types are not stored in the database.
18+
* Subtypes
19+
* Record Types
20+
* Associative Arrays
1421

1522
## Test a PL/SQL Object Type
1623

0 commit comments

Comments
 (0)