Set 110 tasks
DEPARTMENT Table
Create a simple DEPARTMENT table, insert records and run your first filtering, pattern-matching, update and delete queries.
Subject code MC01094031MCA · Semester 1Oracle 10g or above
GTU MCA Semester 1 RDBMS Practical Solutions
Complete Oracle SQL, PL/SQL Programs, Practical Solutions, Viva Questions and Study Notes. Every practical set from the GTU syllabus, solved in Oracle with explanations, sample data and expected output — written for students who are just starting with databases.
Start learning
Everything for the RDBMS lab and theory exam in one place.
Practical SolutionsAll 10 official sets solved step by stepSQL CommandsDDL, DML, joins, subqueries and morePL/SQL ProgramsBlocks, cursors, procedures, triggersRDBMS NotesTheory for all 5 syllabus unitsViva QuestionsShort answers you can say aloudDownloadsReady-to-run .sql scripts
The 10 practical sets
Official set numbering from the GTU MCA Semester 1 RDBMS practical list.
Set 223 tasks
EMPLOYEE and DEPARTMENT
Build two related tables with full integrity constraints and answer the 23 official tasks on employees, salaries, birthdays and experience.
Set 346 tasks
Salesmen, Customers and Orders
The salesmen–customers–orders database: the 46 official queries, from simple filtering to correlated subqueries and set operators.
Set 44 tasks
PL/SQL Blocks, Functions and Procedures
Your first PL/SQL programs: an anonymous block, two stored functions and a stored procedure.
Set 519 tasks
Entrance Examination Database
The EXAM database of applicants, entrance tests and centres: the 19 official tasks from updating IDs to relational division, a read-only view, procedures and a no-Sunday trigger.
Set 61 task
Employee and Department PL/SQL
A PL/SQL block that reads a department name and lists employees with five or more years of service.
Set 76 tasks
Customer and Order
Customers per country, average order value, an audit trigger, a top-customer function and a month-name procedure.
Set 82 tasks
Employee Salary Slip
A formatted salary slip calculated from the basic pay: HRA, DA, medical allowance, PF, gross and net salary.
Set 91 task
Bank Transaction
A procedure that takes two dates, validates them and prints every deposit and withdrawal in that period with totals.
Set 102 tasks
Employee Cursors and Salary
Total salary with a cursor FOR loop, first as a function, then as a procedure filtered by the first letter of the name.
Popular learning topics
SQL SELECT queriesSQL constraintsJoinsSubqueriesAggregate functionsViews and indexesPL/SQL blocksProcedures and functionsCursors and triggers
How to use this website
- Find your practicalOpen Practicals, pick the set number from your lab list, or search for a keyword such as HAVING or trigger.
- Create the tablesRun the CREATE and INSERT script at the top of the article so your data matches ours.
- Copy a queryEvery code block has a Copy button. Paste it into SQL*Plus or SQL Developer and run it.
- Understand and compareRead the explanation, then compare your result with the Expected Output table below the code.