Query Navigator A Utility for Oracle DBMS

Abstract

This report is about development of a utility for Oracle DBMS, Query Navigator. This utility is developed to retrieve detail information about all database objects. Different types of queries are implemented to display information about static and dynamic views of all database objects or selected database objects. This utility also enables us to user SQL commands like create user , grant role/privileges, alter tablespace and alter user without writing traditional commands at SQL prompt. The Query Navigator provides GUI which is one of the main feature. With the implementation of this user friendly utility , most of the problems faced by DBA and software developer will be solved.