Oracle APEX Change Management System — Capstone Project

Project Overview

This project presents an Oracle APEX-based Change Management System designed to support the controlled management of software change requests, reviews, approvals, testing, deployment, rollback, and audit records.

Technologies

• Oracle APEX

• SQL and PL/SQL

• Oracle Database

Key Features

• Role-based access control

• Change request and review workflow

• Approval and deployment controls

• Testing and rollback records

• Audit trail

Implementation and Testing

This section presents selected screenshots and evidence from the implemented application and the tests performed. The results shown reflect the functionality actually implemented and verified.

Lessons Learned

This project strengthened my practical understanding of database application development, access control, change management, testing, and deployment.

Project Evidence

Project Report

The project report documents the design, implementation, and evaluation of the Oracle APEX Change Management System. It describes the system architecture, role-based access controls, change management workflow, and testing activities, including deployment and rollback verification. Selected project evidence is presented to demonstrate the implemented functionality while keeping the full report and source code private.

bulk collect with dbms

 declare

v_first_name varchar2(1000):='Sunny';

t_no     sys.odcinumberlist;

t_fname  sys.odcivarchar2list;

t_lname  sys.odcivarchar2list;

t_rfname sys.odcivarchar2list;

        cursor emp_c

          is

            select  replace(first_name,'Sundar','Sunny') rfirst_name,

                    first_name,

                    last_name,

                    employee_id

              from  jai;

         type emp_typ

           is table of emp_c%rowtype;

         v_data emp_typ;

    begin

        open emp_c;

        fetch emp_c

           bulk collect

           into v_data;

        close emp_c;

        forall i in 1..v_data.last

          update jai

             set first_name=v_data(i).rfirst_name

           where first_name ='Sundar';

     open emp_c;

     fetch emp_c bulk collect into t_rfname,t_fname, t_lname,t_no;

     close emp_c;

  --

       for x in t_no.first .. t_no.last loop

       dbms_output.put_line('Number = '||t_no(x) ||' The First Name = '|| t_fname(x));

     end loop; 

commit;

end;

/

How to update the records using bulk collect

 declare

v_first_name varchar2(1000):='Sunny';

        cursor emp_c

          is

            select  replace(first_name,'Sundar','Sunny') rfirst_name,

                    first_name,

                    last_name,

                    employee_id

              from  emp_test

where first_name ='Sundar';

         type emp_typ

           is table of emp_c%rowtype;

         v_data emp_typ;

    begin

        open emp_c;

        fetch emp_c

           bulk collect

           into v_data;

        close emp_c;

        forall i in 1..v_data.last

          update jai

             set first_name=v_data(i).rfirst_name

           where first_name ='Sundar';

commit;

end;

Learn Oracle Apex

 Soon will be good article for how to start and learn Apex

Learn Oracle for free

 https://m.youtube.com/watch?v=Q5JM8nWWfnI&list=PLc9GCtRxQqZgvbfREKjy1Vi9X7Rle0Nhs&index=1&t=9s

Case Sensitive Passwords in Oracle Database 11g Release 1

Case sensetive login password

 ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

Yasser

Lear HTML

 https://www.websiteplanet.com/blog/html-guide-beginners/