+PL-SQL in Client-Server Architecture
+Use PL-SQL Anonymous Blocks
+Understand How PL-SQL Gets Executed
+PL-SQL in SQL*Plus
+Use Substitution Variables
+Use the DBMS_OUTPUT.PUT_LINE Statement
ORACLE EĞİTİMLERİ
+PL-SQL in Client-Server Architecture
+Use PL-SQL Anonymous Blocks
+Understand How PL-SQL Gets Executed
+PL-SQL in SQL*Plus
+Use Substitution Variables
+Use the DBMS_OUTPUT.PUT_LINE Statement
+Programming Fundamentals
+Make Use of PL/SQL Language Components
+Make Use of PL/SQL Variables
+Handle PL/SQL Reserved Words
+Make Use of Identifiers in PL/SQL
+Make Use of Anchored Datatypes
+Declare and Initialize Variables
+Understand the Scope of a Block, Nested Blocks, and Labels
+Making Use of DML in PL/SQL
+Use the Select INTO Syntax for Variable Initialization
+Use DML in a PL/SQL Block
+Make Use of a Sequence in a PL/SQL Block
+Making Use of SAVEPOINT
+Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PL/SQL Block
+IF Statements
+Use the IF-THEN Statement
+Use the IF-THEN-ELSE Statement ELSIF Statements
+Use the ELSIF Statement
+Nested IF Statements
+Use Nested IF Statements
+CASE Statements
+Use the CASE Statement
+Use the Searched CASE Statement
+CASE Expressions
+Use the CASE Expression
+NULLIF and COALESCE Functions
+The NULLIF Function
+Use the COALESCE Function
+Simple Loops
+Use Simple Loops with EXIT Conditions
+Use Simple Loops with EXIT WHEN Conditions
+WHILE Loops
+Use WHILE Loops
+Numeric FOR Loops
+Use Numeric FOR Loops with the IN Option
+Use Numeric FOR Loops with the REVERSE Option
+The CONTINUE Statement
+Use the CONTINUE Statement
+Use the CONTINUE WHEN Condition
+Nested Loops
+Use Nested Loops
+Handling Errors
+Understand the Importance of Error Handling
+Built-in Exceptions
+Use Built-in Exceptions
+Exception Scope
+Understand the Scope of an Exception
+User-Defined Exceptions
+Use User-Defined Exceptions
+Exception Propagation
+Understand How Exceptions Propagate
+Reraise Exceptions
+RAISE_APPLICATION_ERROR
+Use RAISE_APPLICATION_ERROR
+EXCEPTION_INIT Pragma
+USE the EXCEPTION_INIT Pragma
+SQLCODE and SQLERRM
+Use SQLCODE and SQLERRM
+Cursor Manipulation
+Make Use of Record Types
+Process an Explicit Cursor
+Make Use of Cursor Attributes
+Put It All Together
+Using Cursor FOR Loops and Nested Cursors
+Use a Cursor FOR Loop
+Process Nested Cursors
+Using Parameters with Cursors and Complex Nested Cursors
+Use Parameters in a Cursor
+Use Complex Nested Cursors
+FOR UPDATE and WHERE CURRENT Cursors
+What Triggers Are
+Understand What a Trigger Is
+Use BEFORE and AFTER Triggers
+Types of Triggers
+Use Row and Statement Triggers
+Use INSTEAD OF Triggers
+Mutating Table Issues
+Understand Mutating Tables
+Compound Triggers
+Understand Compound Triggers
+PL-SQL Tables
+Use Associative Arrays
+Use Nested Tables
+Varrays
+Use Varrays
+Multilevel Collections
+Use Multilevel Collections
+Record Types
+Use Table-Based and Cursor-Based Records
+Use User-Defined Records
+Nested Records
+Use Nested Records
+Collections of Records
+Use Collections of Records
+EXECUTE IMMEDIATE Statements
+Use the EXECUTE IMMEDIATE Statement
+OPEN-FOR, FETCH, and CLOSE Statements
+Use OPEN-FOR, FETCH, and CLOSE Statements
+The FORALL Statement
+Use the FORALL Statement
+The BULK COLLECT Clause
+Use the BULK COLLECT Statement
+Creating Procedures
+Query the Data Dictionary for Information on Procedures
+Passing Parameters into and out of Procedures
+Use IN and OUT Parameters with Procedures
+Creating and Using Functions
+Create Stored Functions
+Make Use of Functions
+Invoke Functions in SQL Statements
+Write Complex Functions
+The Benefits of Using Packages
+Create Package Specifications
+Create Package Bodies
+Call Stored Packages
+Create Private Objects
+Create Package Variables and Cursors
+Cursor Variables
+Make Use of Cursor Variables
+Extending the Package
+Gathering Information About Stored Code
+Get Stored Code Information from the Data Dictionary
+Enforce the Purity Level with the RESTRICT_REFERENCES Pragma
+Overload Modules
+Object Types
+Use Object Types
+Use Object Types with Collections
+Object Type Methods
+Use Object Type Methods
+Making Use of Oracle Supplied Packages to Profile PL-SQL, Access Files, and Schedule Jobs
+Access Files with UTL_FILE
+Schedule Jobs with DBMS_JOB
+Submit Jobs
WhatsApp İletişim