Learn Oracle PL/SQL

Publishing soon...

1. Overview of PL/SQL
1. Blocks and PLSQL
2. Variables and Constants
3. Cursors
2. Fundamentals of PL/SQL

1. Declarations
2. Naming conventions
3. Scope and visibility
4. Expressions and comparisons
2. PL/SQL Data types

1. Predefined Data types
1. Number data types
1. BINARY_INTEGER
2. NUMBER
3. PLS_INTEGER
2. Character data types

1. CHAR
2. LONG, LONG RAW
3. RAW
4. ROWID, UROWID
5. VARCHAR2
2. National Character data types

1. NCHAR
2. NVARCHAR2
3. Large Objects

1. BFILE
2. BLOB
3. CLOB
4. NCLOB
4. Boolean data types

1. BOOLEAN
5. Date, Time data types

1. DATE
2. TIMESTAMP
3. TIMESTAMP WITH TIME ZONE
4. TIMESTAMP WITH LOCAL TIME ZONE
5. INTERVAL YEAR TO MONTH
6. INTERVAL DAY TO SECOND
1. User defined Data types
2. Data type conversion

1. Explicit Conversion
2. Implicit Conversion
3. Conversion of DATE values
3. Control Structures

1. IF and CASE statements

1. IF-THEN
2. IF-THEN-ELSE
3. IF-THEN-ELSIF
4. CASE
1. Iterative Control

1. LOOP
2. WHILE-LOOP
3. FOR-LOOP
2. Sequential Control

1. GOTO statement
2. NULL statement
4. PL/SQL Collections and Records

1. Nested Tables
2. Varrays
3. Multilevel Collections
4. Record
5. SQL Support in PL/SQL

1. Data Manipulation
2. Transaction control
3. SQL Functions
4. SQL Built-in Functions/Procedures
5. SQL Pseudocolumns
6. SQL Operators
6. Exceptions and PL/SQL

1. Overview of PL/SQL error handling
2. Predefined exceptions
3. User defined exceptions
7. Sub programming in PL/SQL

1. Procedures
2. Functions
8. PL/SQL Packages

1. Package Specification
2. Package Body
9. PL/SQL and Object orientation

1. Abstraction
2. Object Type
3. Constructors
10. Native Dynamic SQL

1. Dynamic SQL
2. EXECUTE IMMEDIATE statement
3. Bulk Dynamic SQL
11. PL/SQL application tuning

1. The reasons for bad performance
2. Identifying bad performers
3. PL/SQL features for performance tuning
12. Language Elements
13. PL/SQL Wrap Utility
14. Sample Programs

1. Hello World
2. My first loop program
3. Cursors
4. Variable Scope
5. Bulk processing
6. Stored procedures
15. APPENDIX - SQL You should know
1. Tables
2. Views
1. Materialized Views

Next