DataFusing CloudSQL helps Fusion developers develop and run SQLs, create BI reports, and extract data faster. SQL Worksheet is the key workspace for any SQL developer working with CloudSQL. This blog post covers eight key worksheet features and how CloudSQL improves each for Fusion-specific tasks.
SQL Worksheet in CloudSQL is where the user will enter and edit the SQLs using the features available.
Feature 1: Unlimited Worksheets
In CloudSQL, you can open as many worksheet tabs as you need, each acting as its own editor pane. It means you can keep multiple sets of queries open at the same time. Each worksheet can be connected to a different Oracle fusion environment.
Why is this Important?
When working in Oracle Fusion, you often switch between queries for table checks, BI debugging, or data pulls. Multiple worksheets help you stay organized without having to reopen different SQL files.
Feature 2: Open SQL Files from Multiple Sources
You can quickly open a new blank worksheet, from the local system or from your BI Publisher Catelog.
- New Worksheet – Opens a blank SQL editor for immediate query writing.
- Open Worksheet – Loads a previously saved worksheet from your local drive.
- Open SQL from BI Report – Extracts and opens SQL code embedded in Oracle BI Publisher data models for direct editing and execution.
Further details are discussed in our blog post – Direct BI Server Integration Modify Your BI Data Models Directly from CloudSQL.
Feature 3: SQL Autosave and Management
Every time you run a query in CloudSQL, it is automatically saved in your SQL Library. You can search for your SQLs, save them to your library with a name, and reuse important checks, fixes, and audit queries without rewriting them.
Step 1: Select the SQL Library option from the left menu.
Step 2: Choose the Save SQL option displayed on the right side for that specific SQL query to securely store it for future use.
Step 3: Enter suitable SQL name, Description, and Module.
Step 4: View your SQL in My Library
Also Read: Use the CloudSQL AI Assistant to Fix Your Oracle Fusion SQLs
Feature 4: SQL Auto Complete
Typing long table or column names from your memory can slow you down. You must have typed PER_ALL_PEOPLE _F a hundred times, but you still can make a typo leading to SQL failing at execution, frustration, and rework. CloudSQL’s Auto-Complete helps by suggesting table and column names as you type.
It speeds up your work, reduces mistakes, and helps new users understand the data model without leaving the editor. The suggestions are context-based, making the whole process faster and more accurate.
Table Auto-Complete: Start typing the first few characters of a table name, and CloudSQL instantly displays matching table suggestions.
Column Auto-Complete: Type a column alias followed by a dot, and CloudSQL automatically suggests all available columns from that table.
Feature 5: SQL Formatter
The Formatter in CloudSQL takes care of this for you by automatically organizing your code, adding the right indentation, aligning clauses, and adjusting capitalization to enhance readability.
Well-structured SQL is not only easier to understand but also simpler to debug. It fosters better collaboration among teams, especially when multiple users are working on the same scripts. With just a single click, even the most intricate queries can be transformed into clean, professional-looking code.
The formatter is highly flexible. You can configure it to match your preferred SQL style or your team’s standards. Simply open the Settings panel and adjust the formatting options to suit your needs.
Feature 6: Comment/Uncomment
The Comment and Uncomment feature allows users to easily annotate their code or temporarily disable certain sections of a query.
When you are debugging or optimizing, you might only want to execute specific parts of your SQL. Instead of removing lines, you can comment them out and restore them later when you need them. This approach helps keep your workflow tidy and ensures your query history is preserved for future reference.
Feature 7: Indent/Unindent
CloudSQL makes it easy to manage your code’s indentation, allowing you to shift blocks of code to the left or right with just a few clicks.
Proper indentation is crucial because it visually distinguishes the parts of your SQL, such as nested queries, joins, and case statements. This not only boosts readability but also helps you grasp the structure of your queries quickly, especially when dealing with lengthy scripts.
Feature 8: Describe Table
Understanding table structure is vital before writing queries. The Describe Table option in CloudSQL lets users instantly view column names, data types, and constraints.
Instead of switching to a browser to search for Oracle Fusions Tables and Views documentation, users can access metadata directly in the worksheet. This helps confirm column details and prevents errors related to incorrect field references or data types.
Step 1: Select the table name, or place your mouse pointer over the table name and left-click. A menu will appear with the option Describe Table.
Step 2: Choose Describe Table to view the table’s columns, data types, and other details.
Feature 9: Database Browser
The Database Browser in CloudSQL provides a clear visual representation of all your database objects, including tables, views, indexes, and schemas.
This tool allows users to dive into data structures, open objects right in the worksheet, or simply drag and drop names into their queries. It effectively connects schema navigation with query writing, making CloudSQL an incredibly cohesive tool for managing Oracle Fusion data.
You can further drill down to tables and column structure from your database structure.
At DataFusing, we are constantly improving CloudSQL for you by adding more and more features. Click here to start 30 Days Free Trial today.
Suggested Read: Bind Variables Support for Oracle Fusion SQLs in CloudSQ
