Oracle 1Z0-183 study plan

Declare and initialize variables using scalar types, %TYPE, and %ROWTYPE anchors, and assign values inside executable sections

Write nested and labeled blocks and apply variable scoping and visibility rules correctly

Code handlers for predefined, non-predefined (PRAGMA EXCEPTION_INIT), and user-defined exceptions, including RAISE and RAISE_APPLICATION_ERROR

Trace exception propagation across nested blocks and decide where to handle versus re-raise

Use SQLCODE, SQLERRM, and DBMS_UTILITY.FORMAT_ERROR_STACK inside handlers

Create stored procedures and functions with IN, OUT, and IN OUT parameters and invoke them from anonymous blocks

Choose between a procedure and a function for a given requirement and justify parameter modes and default values

Build a package with a specification and body that separates public and private program units

Overload subprograms inside a package and state the rules the compiler uses to resolve an overloaded call

Apply AUTHID DEFINER versus AUTHID CURRENT_USER and predict the effect on name resolution

Create BEFORE and AFTER row-level and statement-level DML triggers with correct timing, granularity, and WHEN conditions

Write an INSTEAD OF trigger on a view and explain the mutating-table restriction and at least one workaround

Query USER_OBJECTS and USER_DEPENDENCIES to map dependency chains and identify invalid objects

Recompile invalid program units and describe when the database invalidates dependent objects automatically

Enable and interpret PL/SQL compiler warnings via PLSQL_WARNINGS and the DBMS_WARNING interface, and wrap source with the PL/SQL wrapper

Declare, open, fetch from, and close explicit cursors and test %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN

Convert explicit cursor logic into cursor FOR loops and write parameterized cursors

Lock rows with FOR UPDATE and apply WHERE CURRENT OF to update the fetched row

Declare and populate associative arrays, nested tables, and VARRAYs, and manipulate them with collection methods such as COUNT, EXISTS, FIRST, NEXT, and TRIM

Combine records and %ROWTYPE with collections to hold a fetched result set in memory