OracleHCMCloudWorld

Ref Source Hierarchical Queries #GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E" target="_blank" rel="nofollow noopener">docs.oracle.com/en/database/or… Hierarchical Query Pseudocolumns #GUID-2F2FBA6F-2FD1-47D6-A74F-DB4B31E4D400" target="_blank" rel="nofollow noopener">docs.oracle.com/en/database/or…

How to identify circular reference 🔃 in your enterprise data hierarchy 🤔 build hierarchical queries using CONNECT BY, NOCYCLE, CONNECT_BY_ISCYCLE Refer the illustration for more details #sql #oraclesql #oracleace @oracleace

@oracleace Some ref links python-oracledb.readthedocs.io/en/latest/inde… oracle.github.io/python-oracled… oracle.com/database/techn… github.com/oracle/python-…

Unlock epic data magic !! - (1/2) Imagine if you can leverage the flexibility of python 🐍libraries on Oracle data 🗄️ Try : python-oracledb driver @oracleace #oracleace #pythonlearning #oracle #database

SQL Series | CTE Usage Here is an example where Common Table Expressions (CTEs) can used on HCM table. For more details, follow my blog - oraclehcmcloudworld.blogspot.com @oracleace #oracleace #SQL

Oracle AI World Tour Sydney | 24 Mar 26 Personally looking forward to the Hands On Lab on Oracle AI Agent Studio (OAIAS) @oracleace #oraclace @Oracle #OracleAIWorldTour oracle.com/au/ai-world-to…

For official documentation please refer #common-table-expressions?v=1" target="_blank" rel="nofollow noopener">docs.oracle.com/cd/E17952_01/m… @oracleace #SQL

SQL Series | Common Table Expressions (CTEs) Ever encountered a situation where you are staring at a lengthy SQL with multiple subqueries in it, buried 5-6 levels deep 😕 Try using CTEs, think of it as nicknaming your subquery which you can reference multiple times #oracleace

For more details on the COALSCE function, you can refer to official oracle documentation here docs.oracle.com/en/database/or…

SQL Series | Try COALESCE function Tired of using NULL in your SQL queries, try COALESCE. It's an SQL standard conditional function which evaluates a list of expressions Left 2 Right, returning the 'first Non-NULL' value @oracleace #oracleace

♠️ Oracle ACEs ♠️ Reminder to join our ACE-only session, “Oracle ACE Product Overview: From SQL Patterns in Event Logs to Graph Insights — Intro to Process Mining.” Learn how event logs + MATCH_RECOGNIZE, graph modeling, and live demos reveal workflows, bottlenecks, and anomalies (Speaker: Hans Viehmann). #OracleACEs

SQL Aggregate Functions (part i) COUNT SUM LISTAGG For complete details, click on oraclehcmcloudworld.blogspot.com/2026/03/sql-se… @oracleace #oracleace

Sydneysiders!! Come and be part of Oracle AI World Tour on March 26th oracle.com/au/ai-world-to… @oracleace #oracleace

What are 'TOPICS' in Oracle AI Agent Studio 🤔🤔 Here is a two-part series explaining one of the key architectural components of AI Agent Part 1/2 - oraclehcmcloudworld.blogspot.com/2026/02/oracle… Part 2/2 - oraclehcmcloudworld.blogspot.com/2026/02/oracle… If you like more, Follow #oracleace @oracleace

If you are new to Oracle AI Agent Studio (OAIAS) and not sure where to begin with 🤔🤔🤔 Maybe this can help you ... oraclehcmcloudworld.blogspot.com/2026/01/oracle… For more such interesting post , do check out - oraclehcmcloudworld.blogspot.com #oracleace @oracleace