Category: Oracle Apex
-
Writing a PL/SQL code for Student Transcript Analyzer in Oracle Apex
This PL/SQL block appears to be designed to retrieve and process information from a database table called utas_transcript. Let’s break it down step by step: Overall, this block is fetching information about the courses attempted by each student from the utas_transcript table and printing out the course number along with the number of attempts for…
-
Oracle Apex – Creating a Schema from imported Excel file with Normalization
BTECH DATABASE SPECIALIZATION STUDENTS * ITDB4200 * ADVANCED DATABASE TECHNIQUES * ORACLE APPLICATION EXPRESS 20.1 * IT DEPARTMENT * UNIVERSITY OF TECHNOLOGY AND APPLIED SCIENCES * MR. HANSEL DELOS SANTOS * DB LECTURER
-
Oracle Apex for Beginners: An Introduction to Rapid Application Dev
Hi, I am Hansel Delos Santos, lecturer from the Information Department- University of Technology and Applied Sciences. Welcome to this short course on Oracle Apex for Beginners. This course is designed for business people, managers, employees, students and basically anyone without a programming background but it is interested to learn about Oracle Apex concepts in…
-
Developing a Retrieval Augmented Generation (RAG) with Vector Database Functionality for Generative and Custom AI and ML using Oracle APEX Rapid Application Low Code Development
Abstract The developer-facing user interface of the prototypical Generative AI system is called the “APEX Assistant” within the Oracle APEX application development platform. In the context of this research project, the APEX Assistant is enabled for every SQL code editor; wherever the developer would have previously been asked to write SQL code, the APEX Assistant can be used…
-
Oracle APEX – Creating a complex VIEW objects (Join tables, group aggregation)
University of Technology and Applied Sciences – Salalah – ITDB401 Advanced Database Application Lecturer in Oracle Apex “Creating Complex View Objects” June 20, 2021
-
Oracle Apex – Server Side Condition Lecture
Advanced Database Application Course Lecturer: Mr. Hansel Delos Santos University of Technology & Applied Science – Salalah Sultanate of Oman
-
RAD (Rapid Application Development) using Oracle Apex 20.2c Webinar
University of Technology and Applied Sciences – Salalah Information Technology Department Database Section March 23, 2021 12:00 – 2:00 PM Facilitator: Mr. Hansel Delos Santos
-
Comprehensive Student Grades Scenario
Comprehensive Student Grade Scenario Version 1.0 was Developed in Oracle Apex 23.1 for Academic Record Management System (ARMS) in the University of Technology and Applied Sciences (UTAS) – Salalah, Sultanate of Oman. Content: 0. Familiarization of the Comprehensive Student Grade Scenario page (00:00) 1. Downloading Transcript in CIMS (00:45) 2. Uploading Guide (1:24) 3. Modifying…
-
Academic Record Management System – ARMS (Part 1)
Class Record Version 4.0 was Developed in Oracle Apex 23.1 for Academic Record Management System (ARMS) in the University of Technology and Applied Sciences (UTAS) – Salalah, Sultanate of Oman. Content: 1. List of Course Page 2. Class Record Page 3. Setting the Assessments 4. Entering Marks in Class Record Grid Form 5. Printing Mid/Final…