Smart Code Formatting
Easily format any Oracle SQL query using the in-built Smart SQL Formatter
Select and Execute What You Want
Select and Execute What You Want With Oracle SaaS Query Tool.
History of Run Queries
History of all the queries which were run against each of the Cloud POD connection
Supports Network Proxy
Supports company’s proxy server so the tool can access the internet needed to connect to Oracle Cloud PODs
Smart Code Completion
Auto-complete and present you with table and column names as you type in your queries
Table Object Details
For a given Cloud table, view its column details, constraints, indexes and many other information.
Support Bind Parameters
Just add :paramName in your query and it automatically asks your for the parameters when you run the query
View Object Details
For a given Cloud database view, see the SQL behind the view along with column information
Multiple PODs and Multiple Worksheets
Simultaneously connect to multiple PODs and easily create multiple SQL Worksheets per connection
Multi Format Export
Any query result can be exported in many formats such as Excel, HTML, CSV, Text, etc…
Index Object Details
For a given Table Index, view its columns and many other information.
Intuitive Connection Manager
Easily create connection to different Cloud environments using just the POD URL
Smart Code Snippets
Easy to save your reusable SQL snippets and then pull them directly as you type in your query with accelerator keys
One Click Export
Quick export action sits right on top of the results table and thus can be invoked easily to export the results table with minimal clicks.
Tabular Formatted Output
View the Cloud query results in a tabular format like any other desktop SQL IDE. You can also copy and paste the results as needed.
Custom Delimited Export
While exporting the data, if you need the output in any other delimited format, then use the delimiter configuration option to provide the required details.
Quick Column Finder
Speed search and bring to focus any column which is part of the results table. This saves a lot of time while carefully navigating to the desired column.
If the query results table contains too many columns to place on the screen, use the Transposed View to see the data from a particular row in a friendlier way.
Package Specification Details
View the package specification details of any Cloud database PL/SQL package. This will help you get the signatures of many PL/SQL package functions to be used in your custom queries.
Browse Cloud Database Objects
Search any Oracle Cloud database object using wild-card characters and get the results back in a nice tabular format. Directly click on the open definition to view the details of the selected object.
Find data inside the results table quickly without writing a statement thanks to text search. It’s especially helpful if you don’t know which column contains the data.
CloudMiner is the only Data Query Tool that provides SQL access to your Oracle SaaS Database.
- Run ad-hoc queries (provided by IT) on your own
- Export and analyze data in spreadsheets
- Quickly compare setups across multiple points of delivery
- Run queries while debugging, and on production databases
- Quickly monitor running processes in Oracle Cloud Applications like HDLs, HCM Extracts, etc.
- Develop ad-hoc queries faster using auto-completion and snippet shortcuts
- Standardize code using snippets for standard queries
- Deliver actionable insights with easy-to-build visualizations
Why Choose CloudMiner
Time Savings: Over 963 More Efficient!
CloudMiner performs the same task In just 3.4% of the time otherwise needed!
Task: A query with 7 tables joined together; generating a 15-column results output in Excel