1. Introduction to Composite Data Types
2. Record Types (PL/SQL Records)
3. Table Types (Nested Tables)
4. VARRAY Types (Variable-Size Arrays)
5. Associative Arrays (Index-by Tables)
6. Defining and Using Records
7. Nested Tables vs. VARRAYs
8. Creating and Using Nested Tables
9. Creating and Using VARRAYs
10. Index-by Tables (Associative Arrays)
11. Associative Arrays vs. Nested Tables
12. Manipulating Records in PL/SQL
13. Manipulating Nested Tables in PL/SQL
14. Manipulating VARRAYs in PL/SQL
15. Composite Data Types in Stored Procedures and Functions
16. Using Composite Types in DML Statements
17. Indexing Nested Tables and VARRAYs
18. Persistent Storage of Composite Types (Database Table Columns)
19. Using Composite Data Types with Cursors
20. Composite Data Types in PL/SQL Collections
21. Associative Arrays with PL/SQL
22. Composite Data Types and Bulk Collect
23. Passing Composite Types as Parameters
24. Defining Table Columns with Nested Tables or VARRAYs
25. Handling Null Values in Composite Data Types
26. Using Record Types in Object-Oriented Programming
27. Using Collection Methods for Nested Tables and VARRAYs
28. Serialization and Deserialization of Composite Data Types
29. Composite Data Types in PL/SQL Triggers
30. Optimizing Performance with Composite Data Types
No comments:
Post a Comment