1. Introduction to Executable Statements
2. PL/SQL Assignment Statement (SET and :=)
3. Executing SQL Statements in PL/SQL
SELECT INTO
INSERT INTO
UPDATE
DELETE
4. Using DML Statements in PL/SQL Blocks
5. Using DDL Statements (CREATE, ALTER, DROP) in PL/SQL
6.
Using Dynamic
SQL with EXECUTE
IMMEDIATE
7. Controlling Transactions with COMMIT, ROLLBACK, and SAVEPOINT
8.
Using RETURN in Functions and Procedures
9. Calling PL/SQL Procedures and Functions
10. PL/SQL Control Structures
IF-THEN-ELSE
LOOP, FOR, WHILE
CASE Expression
11. Using EXIT and CONTINUE in Loops
12. Using GOTO for Flow Control
13. PL/SQL Exception Handling (RAISE, WHEN, EXCEPTION)
14. Invoking Built-in Oracle Functions in PL/SQL
15. Using DBMS_OUTPUT for Debugging and Output
16. Conditional Execution of SQL Statements
17. Using Cursors in Executable Statements
18. Using FORALL and BULK
COLLECT for Bulk
Operations
19. Executing PL/SQL Blocks from SQL*Plus or SQLcl
20. Handling Errors and Exceptions in Executable Statements
21. Handling Data Types with TO_NUMBER, TO_CHAR, etc.
22. Dynamic SQL with DBMS_SQL Package
23. Transaction Control Inside PL/SQL Blocks
24. Using RETURN to Exit Loops and Functions Early
25. Executing Remote SQL Statements from PL/SQL
26. Using WITH Clause for Inline Views in PL/SQL
27. Using MERGE Statement in PL/SQL
28. Executing Multiple SQL Statements in a Single Block
29. PL/SQL and External Program Calls (External Procedures)
30. Using RAISE_APPLICATION_ERROR for Custom Error Handling
No comments:
Post a Comment