Overview

Oracle Master connects to an Oracle 11g database powering the UMIS system for academic and management tasks. Users can query student records, inspect table structures, and apply fixes directly. It delivers precise control over transcript data and related tables without manual SQL access.

Key Capabilities

list_tables lists all academic and management tables available in the database.
`
get_table_schema outputs column names and data types for any specified table.

Use Cases

An admin retrieves a student's full academic report via get_student_full_report

Who This Is For

Database administrators and developers managing UMIS systems. University IT staff handling student data. Requires intermediate SQL knowledge and familiarity with Oracle environments.