74 docs tagged with "oracle"

Complete practical lab exercises for BCA Semester 2 students with Oracle/MySQL implementation

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.

Master logical operators in Oracle SQL. Learn how to combine multiple filters in a WHERE clause using AND and OR with operator precedence rules.

Master the BETWEEN operator in Oracle. Learn how to filter numbers and dates within inclusive ranges for efficient data extraction.

Learn how to enforce data integrity in Oracle Database. Master Primary Keys, Foreign Keys, and business logic with CHECK constraints.

A complete guide to Oracle data types. Understand the difference between CHAR and VARCHAR2, and master NUMBER, DATE, and TIMESTAMP.

Master the DISTINCT keyword in Oracle to eliminate duplicate data from your queries. Understand how it applies to single and multiple columns.

Master Data Manipulation Language in Oracle. Learn how to add, modify, and remove data from your tables with safety and precision.

Learn how to use the FETCH FIRST and OFFSET clauses in Oracle 12c+. Master modern pagination techniques without using ROWNUM.

Master the FULL OUTER JOIN in Oracle. Learn how to combine all records from both tables, filling in NULLs where no matches exist.

Learn how to use GROUP BY and HAVING in Oracle SQL. Master categorical reporting and filtering aggregated results like a professional.

Learn how to use the IN operator in Oracle SQL to filter data against a list of values or subquery results. Simplify multiple OR conditions.

Learn how Oracle Indexes work. Master B-Tree, Bitmap, and Function-based indexes to boost query performance in high-demand apps.

Master the Oracle INNER JOIN. Learn how to combine related tables based on common columns using the ON clause. Includes performance tips.

Learn how to use Oracle's INSERT ALL statement to add data into multiple tables in a single operation. Master conditional and unconditional multitable inserts.

Master the concept of NULL in Oracle. Learn why you cannot use = with NULL and how to correctly filter missing or unknown values.

A quick visual summary of all Oracle Join types including Inner, Left, Right, Full, and Cross. Master the logic at a glance.

Learn how to use Oracle Outer Joins. Understand how to keep all records from one table even if no matching record exists in the joined table.

Learn pattern matching in Oracle using the LIKE operator. Master the % and _ wildcards to find partial strings in your database.

Master the Oracle MERGE statement. Learn how to perform an Insert or Update in a single operation based on data existence.

Learn how to sort query results in Oracle using ORDER BY. Master ASC, DESC, and NULLS FIRST/LAST keywords for professional data presentation.

Master advanced data transformation in Oracle. Learn how to convert rows to columns with PIVOT and rotate columns to rows with UNPIVOT.

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.

Master Oracle's powerful grouping features. Learn how to generate subtotals and grand totals using ROLLUP, CUBE, and GROUPING SETS.

Master the Oracle SELECT statement. Learn how to retrieve data, use expressions, and perform arithmetic in Oracle Database.

Learn advanced join techniques in Oracle. Master SELF JOIN for hierarchies and CROSS JOIN for generating Cartesian products.

Learn how to use Sequences in Oracle Database to generate primary key values. Master CREATE, ALTER, and DROP SEQUENCE commands.

Master Oracle set operators. Learn how to combine or subtract query results using UNION, UNION ALL, INTERSECT, and MINUS.

Learn advanced data selection in Oracle using subqueries. Master Correlated queries, EXISTS vs IN, and ANY/ALL comparisons.

Learn how to use Oracle Synonyms to create aliases for database objects. Improve security and simplify cross-schema querying.

Master Oracle DDL. Learn how to create tables, manage identity columns, use virtual columns, and safely modify structures.

Learn how to use Oracle Temporary Tables for intermediate data processing. Understand the differences between Global and Private temp tables.

Master Oracle Views. Learn how to create updatable views, use inline views, and enforce security with WITH CHECK OPTION.

Learn how to filter data in Oracle using the WHERE clause. Master comparison operators like =, <>, >, < to extract exact data subsets.

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.

Learn Data Definition Language (DDL) in Oracle. Master how to create, modify, and delete table structures using the Architect's Blueprint scenario.

Master Data Manipulation Language (DML) in Oracle. Learn how to add, change, and remove data within your tables using the Warehouse Manager scenario.

Comprehensive SQL lab exercise for BCA Sem 2. Includes 23 solved queries covering Joins, Subqueries, and Aggregate Functions with an Employee-Project scenario.

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