Blog

ER diagram
CloudSQL

Querying for Employee Invoices in Oracle Cloud

It is common to need to query invoices generated by employees. However, the relationship between the AP_INVOICES_ALL and PER_ALL_PEOPLE_F tables is not straightforward. These tables are connected through the HZ...

Extract User Details
CloudSQL Desktop Documentation Oracle ERP SQL Editor

How to Extract All User Details from Oracle Fusion

Extract User Details from Oracle Fusion involves understanding key tables and their relationships. This guide explains how to Extract User Details from Oracle Fusion efficiently. Key Points to Note: ...

Oracle Fusion SQL Editor
CloudSQL CloudSQL Desktop Documentation Oracle BI Oracle ERP SQL Editor

Why do I need an SQL Editor for Oracle Fusion?

This is a question we often hear—especially from new managers working with Oracle Fusion technical teams. And it’s a great one! Let’s break it down into two simple parts: Part 1: Why Do We Need to Run SQL...

ChatGPT Image Jun 5, 2025, 09_26_59 AM
CloudSQL CloudSQL Desktop Documentation Oracle BI Oracle ERP SQL Editor

Can I use SQL Developer or Toad to connect to the Oracle Fusion database?

This is one of the most common questions developers ask when they start working with Oracle Cloud: Can they use SQL Developer with Oracle Fusion? Unfortunately, the answer is no. Oracle doesn’t provide di...

How to Run SQL on Oracle Fusion Cloud (HCMERPSCM) (1)
CloudSQL CloudSQL Desktop Documentation Oracle BI Oracle ERP SQL Editor

How to Run SQL on Oracle Fusion (HCM/ERP/SCM) Database?

If you’re working with Oracle Fusion Cloud and want to run SQL queries directly on the database, you might find it a bit tricky at first. Oracle doesn’t provide direct database access like traditional systems. ...

Can You Fix This SQL Error
AI CloudSQL CloudSQL Desktop Debugging Oracle ERP SQL Editor

Think You’re Good at SQL? Let’s Put That to the Test (and Show You Something Cool at the End)

At CloudSQL Online, our users have run millions of SQL queries. And while most of them fly through just fine, we’ve noticed that around 1 in 10 ends up throwing a syntax or runtime error. Surprising? Not ...

image (1)
AI CloudSQL CloudSQL Desktop SQL Editor

ChatGPT for SQL? 4 Must-Know tips for Oracle Developers

We recently posed a simple question to our most dedicated CloudSQL SQL Editor users: Are you using AI? The answer? No surprises there—everyone has tried ChatGPT or its equivalents at some point. But her...

sql coder
AI CloudSQL CloudSQL Desktop Debugging Oracle BI Oracle ERP SQL Editor

Master Oracle BI SQL: 5 Tips to Write Faster, Smarter Queries

Oracle BI SQL development plays a crucial role in generating reports and insights from Oracle ERP databases. As an Oracle BI developer, improving efficiency can save valuable time and optimize query performance...

CloudSQL Desktop

Effortless Logins: Try SSO with CloudSQL Desktop Today

Simplify Access with Single Sign-On (SSO) for Oracle Fusion Cloud ERP and DataFusing CloudSQL Desktop Single Sign-On (SSO) with Oracle Fusion Cloud ERP enhances user convenience and security by allowing seam...

Image showing all the new features in CloudSQL Desktop
CloudSQL Desktop

CloudSQL Desktop: September Update is Here!

We’re excited to announce the September release of CloudSQL Desktop, packed with numerous improvements and bug fixes to enhance your SQL development experience. Here’s a quick overview of the latest...

image
CloudSQL

Exciting Update: Bind Variable Support Now Available in CloudSQL

We are thrilled to announce that bind variable support is now available in DataFusing CloudSQL Desktop! This new feature enhances your ability to run SQL queries against Oracle Cloud with greater efficiency and...