OI is a comprehensive software tool designed for Oracle SQL development and DBA tasks, featuring a user-friendly Windows-based interface for efficient T-SQL development. The software targets Oracle DBA professionals and developers running on Microsoft Windows platforms.
One of the primary benefits is that Oracle Interrogator reduces Oracle training requirements. With its use of Windows standard intuitive interfaces, no training is required as it leverages existing knowledge. Additionally, managing SQL scripts is made more efficient, as the tool reduces time needed.
Collaborative working is also made easier with the 'Favourites' repository to common network locations. The tool also features colour coding to make writing SQL scripts a simpler task.
Oracle Interrogator boasts an array of useful features. Queries can be run against an Oracle 7/8/9/10 database, and execution plans can be viewed for query optimization. The tool also offers a cost or rule based optimizer option, and query timings and statistics are available.
A user object browser and a dictionary object browser are included in the tool, as well as rowset restriction support. Query results can be exported to a variety of formats including CSV or direct to file, and the tool is SQLNet / Netx compliant.
For quick access to saved queries, Oracle Interrogator offers query favourites. Further, multiple query windows make it an efficient tool for software development, and quick table and view data access can be achieved. Overall, Oracle Interrogator provides a comprehensive solution for Oracle DBA's and software developers looking to streamline their development process.
Version 2.0.4: A number of updates including order by and additional space fixes.
Version 2.0.3: A number of updates including order by and additional space fixes.
Version 2.0.1: N/A