Analytical Tool for Oracle SQL Statements
Lukas Jancik, Michal Kvet · 2024
Writing statements in Structured Query Language for database querying is one of key activity when learning database systems. Tasks which should be resolved with the stored data using such statements have usually textual character, and evaluation of such statement if it is correct or not typically involves manual check of person responsible for the knowledge provision. The manual check is needed because the correct statement can take various form, which results from the capabilities of the language itself. In this paper, there is presented a solution which performs the evaluation in the automatic way. There are few ways how to compare the statements, the way used is to compare statements itself. This solution deals also with the procession of the input, which is plain text version of statement. This input is considered to come from human who could perform some mistakes in sense of intentional and unintentional mistakes. Unintentional mistakes cover typos and intentional mistakes cover both syntax errors and runtime errors. The software application which was evolved to perform this evaluation is a complex tool, which on one site is highly configurable allowing to modify its behaviour during the evaluation according to user’ preference, on the other site it provides all information concerning the execution run to the user.