40 docs tagged with "plsql"

Master BCA Semester 2 with comprehensive RDBMS tutorials, SQL programming, PL/SQL development, and database management.

Learn how to capture unexpected errors in PL/SQL using the WHEN OTHERS clause. Master SQLCODE and SQLERRM for professional error logging.

Learn how to return query results directly from Oracle procedures using DBMS_SQL.RETURN_RESULT. Master modern result handling in Oracle 12c+.

Learn how to use INSTEAD OF triggers in Oracle to perform DML on non-updatable views. Master view automation and abstraction.

Learn how to create and execute PL/SQL Procedures. Master parameters (IN, OUT, IN OUT) and understand modular programming in Oracle.

Master Oracle PL/SQL. Learn block structure, variables, cursors, and triggers using our story-driven roadmap. Perfect for BCA and enterprise database learners.

Learn the structure of a PL/SQL anonymous block. Understand the DECLARE, BEGIN, EXCEPTION, and END sections with practical examples.

Learn how to use the basic LOOP statement in PL/SQL. Master the EXIT and EXIT WHEN clauses to control loop termination safely.

Learn how to use the CASE statement in PL/SQL. Master simple CASE and searched CASE expressions for cleaner, more efficient conditional logic.

Master Oracle PL/SQL collections. Learn how to work with Associative Arrays (Index-by Tables), Nested Tables, and VARRAYs for high-performance memory handling.

Learn how to use comments in PL/SQL. Understand single-line and multi-line comment syntax and best practices for clean, readable code.

Learn how to use constants in PL/SQL. Understand why some values should never change during program execution and how to declare them.

Master the CONTINUE statement in PL/SQL. Learn how to skip specific iterations within a loop without terminating the entire loop process.

Master PL/SQL conditional logic and loops with 5 solved problems including Salary Grade calculation, Even number generation, and Annual Salary logic.

Master the Cursor FOR LOOP in PL/SQL. Learn how to process multiple rows with automated opening, fetching, and closing.

Learn how to use cursors with parameters in PL/SQL. Create reusable, dynamic data queries by passing values during the OPEN operation.

Master advanced data retrieval in PL/SQL with 7 solved exercises covering SELECT INTO, Implicit/Explicit Cursors, and Exception Handling.

Master Oracle cursors. Learn how to handle multi-row result sets using Explicit cursors and understand how Implicit cursors work automatically.

Learn how to use PL/SQL to automate complex payroll calculations (HRA, DA, PF) during data insertion into Oracle tables.

Understand PL/SQL data types. Learn about scalar types, Boolean, and the powerful %TYPE anchored declaration for dynamic column matching.

Master Oracle PL/SQL exception handling. Learn how to trap built-in errors and create user-defined exceptions to keep your programs stable.

Understand how exceptions propagate in PL/SQL nested blocks. Learn how errors travel from inner blocks to outer handlers in Oracle Database.

Master PL/SQL Functions in Oracle. Learn how to create reusable calculations and understand the key differences between Functions and Procedures.

Understand the GOTO statement in PL/SQL. Learn how to jump to specific labels and why this command should be used with extreme caution.

Master IF-THEN logic in PL/SQL. Learn how to use IF-THEN-ELSE and IF-THEN-ELSIF to control the flow of your Oracle programs.

Learn how to use the NULL statement in PL/SQL. Understand why a command that does nothing is essential for placeholder logic and labels.

Learn how to use the Numeric FOR LOOP in PL/SQL. Understand the loop index, range syntax, and the REVERSE keyword for counting downwards.

Learn how to organize PL/SQL procedures and functions into Packages. Master the Package Specification and Body for professional code management.

Learn how to fetch records from multiple related tables using PL/SQL SELECT INTO. Includes error handling for missing patient records.

Learn how to update calculated columns in Oracle using PL/SQL. Master the logic of deriving Total Sales from Unit Price and Quantity.

Learn how to manually trigger exceptions in PL/SQL. Master the RAISE statement and create professional error codes using RAISE_APPLICATION_ERROR.

Learn how to use PL/SQL records to group related data. Master user-defined records and the powerful %ROWTYPE for whole-row processing.

Master dynamic cursor handling in PL/SQL using REF CURSOR. Learn how to pass cursors between procedures and functions for modular code.

Master the SELECT INTO statement in PL/SQL. Learn how to fetch single rows from Oracle tables into local variables safely.

Master Oracle database triggers. Learn how to automatically fire code before or after DML operations for auditing and security.

Learn how to update or delete rows through a cursor in PL/SQL. Master the FOR UPDATE and WHERE CURRENT OF clauses for precise row manipulation.

Master PL/SQL variables. Learn how to declare variables, assign values using := and SELECT INTO, and understand variable scope.

Master the WHILE loop in PL/SQL. Learn how to repeat code as long as a condition remains true with practical examples and performance tips.

Your central resource for learning SQL and database management. Master universal concepts and explore dialect-specific features for Oracle, MySQL.

Understand the core concepts of PL/SQL (Procedural Language/Structured Query Language). Learn about its architecture, benefits, and how it extends standard SQL.