Skip to content
Logo 0121 - SQL Connect: A Robust alternative to TOAD and SQL Developer for Oracle Cloud
Menu
  • Home
  • VIP Access
    • Log In
    • Manage VIP Account
    • Register for VIP Plan
    • VIP Member-Only Content
  • Blog
  • About Us
  • Technical
    • HCM Data Loader
    • HCM Extract
    • BI Publisher
    • Fast Formula
    • Security
    • OTBI Analytics
    • Personalizations
    • Scheduled Processes
  • Functional
    • Core HR
    • Absence Management
    • Payroll
    • Benefits
    • Performance Management
    • Talent Management
    • Time & Labor
    • Helpdesk
    • Learning
    • Recruiting
    • Onboarding
  • Interview Tips
    • HCM Extracts Questions
    • HCM Data Loader Questions
    • BI Reports Questions
  • Log In
    • Generic filters
      Exact matches only
      Search in title
      Search in content
      Search in excerpt
  • Home
  • VIP Access
    • Log In
    • Manage VIP Account
    • Register for VIP Plan
    • VIP Member-Only Content
  • Blog
  • About Us
  • Technical
    • HCM Data Loader
    • HCM Extract
    • BI Publisher
    • Fast Formula
    • Security
    • OTBI Analytics
    • Personalizations
    • Scheduled Processes
  • Functional
    • Core HR
    • Absence Management
    • Payroll
    • Benefits
    • Performance Management
    • Talent Management
    • Time & Labor
    • Helpdesk
    • Learning
    • Recruiting
    • Onboarding
  • Interview Tips
    • HCM Extracts Questions
    • HCM Data Loader Questions
    • BI Reports Questions
  • Log In
  • Search
    • Search

Blog

SQL Connect: A Robust alternative to TOAD and SQL Developer for Oracle Cloud

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:April 5, 2021
  • Reading time:5 mins read

Do you know that there is a robust alternative to TOAD/SQL Developer for Oracle Cloud? Read on to know more details on SQLConnect.

Continue ReadingSQL Connect: A Robust alternative to TOAD and SQL Developer for Oracle Cloud

SQL Query to get the modified fields from the Assignment table using Audit functionality

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:April 5, 2021
  • Reading time:17 mins read

Do you know how to get the updated/ created/ deleted fields from Audit tables when auditing is enabled? Read on to know more details.

Continue ReadingSQL Query to get the modified fields from the Assignment table using Audit functionality

How to create Data Role based on Job Role

  • Post category:Security
  • Post comments:0 Comments
  • Post last modified:April 3, 2021
  • Reading time:3 mins read

Do you know how to create a data role which inherits the Job role and add security profiles on top of it? Read on to know more details.

Continue ReadingHow to create Data Role based on Job Role

How to Create BI Report using static Excel file .xls

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:July 20, 2023
  • Reading time:4 mins read

Do you know that you can create BI Report based out of a static Excel File from local machine? What would be the use cases and how to do it? Read on to know more details.

Continue ReadingHow to Create BI Report using static Excel file .xls

How to Create BI Report using static CSV file

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:March 21, 2021
  • Reading time:3 mins read

Do you that you can create report based on a static CSV file? You can also integrate the static data with other data sets. Read on to know more details.

Continue ReadingHow to Create BI Report using static CSV file

How to skip the blank line at the end of the output file using etext

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:March 21, 2021
  • Reading time:3 mins read

Do you know how to skip the blank line at the end of file using etext template? Do you think it is possible? Read on to know more details.

Continue ReadingHow to skip the blank line at the end of the output file using etext

SQL Query to get the Object Group Employees

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:March 15, 2021
  • Reading time:1 min read

Do you know how to pull employees assigned to an object group? Read on to know more detaisls.

Continue ReadingSQL Query to get the Object Group Employees

HCM Extracts Infographics

  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:March 14, 2021
  • Reading time:1 min read

Check out the HCM Extract Infographics to get an idea on the HCM Extracts features, types, building blocks, delivery options, changes only modes and Output types supported.

Continue ReadingHCM Extracts Infographics

Ready to use Worker Sample HDL files for multiple scenarios

  • Post category:HCM Data Loader
  • Post comments:0 Comments
  • Post last modified:March 6, 2021
  • Reading time:3 mins read

Do you have the Worker HDL files handy for multiple scenarios? Are you aware of which attributes are required for global transfer/ termination/ rehire etc? Read on to know more details.

Continue ReadingReady to use Worker Sample HDL files for multiple scenarios

How to use Regular Expressions in SQL Query?

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:March 6, 2021
  • Reading time:2 mins read

Do you know how to use regular expressions in SQL Queries? Read on to know more details.

Continue ReadingHow to use Regular Expressions in SQL Query?
← Newer Posts
Older Posts →

Search Knowledgebase

Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
Advertisements

VIP Membership Plans

VIP Membership 296x300 - How to use Regular Expressions in SQL Query?
Advertisements
Advertisements
Advertisements

Recent Posts

  • SQL query to pull Payroll Run Results for employees with multiple assignments?
  • How to get the return value of Table Valueset in FF from SQL Query?
  • Advanced Edit not available for HCM Extracts from 24D
  • How to get the count of data loaded using HDL for business objects?
  • How do we extract the Grade Ladder step rates?
  • How do we reduce RTF template size when many images exist in the template?
  • How to find the Lookup Type for an attribute that supports HDL load?
  • How to modify the reports/value sets for Payroll table changes in 24A?
  • What is a Progression Grade Ladder and how to load it using HDL?
  • How to resolve “Template type etext is not yet supported” error for BI Report?
Advertisements

Tag Cloud

Alerts Approvals Audit BI Publisher Bursting Calculation Cards content server Data Disposal Data Scrambling EL Expressions ERD etext Fast Formula Flexfields Functional General HCM Data Loader HCM Extract Helpful Tools Interview Questions Latest Features LBAC Lookup Migration Notifications Offer Letter OTBI Analytics Payroll Payroll Batch Loader Payroll Flow Performance Management Personalizations Profile Options REST Services Scheduled Processes Security SOAP Services SQL Query Tables Templates Transformation Formula UDT Valueset VIP Content Web Services
Advertisements

Archives

Advertisements
[mailpoet_form id="3"]

Quick Links

  • Home
  • About Us
  • Blog
  • VIP Membership Plans
  • Interview Tips
  • FusionHCMKB Tools
  • Report Issues/Suggestions
  • Privacy Policy
  • Contact Us
Linkedin Facebook Twitter Telegram
footer logo - How to use Regular Expressions in SQL Query?

Copyright © FusionHCMKnowledgebase 2026. All rights reserved

Disclaimer: All views expressed on site are my own and does not represent opinions of any entity. Reproducing articles without permission is prohibited.

Close Menu
Menu
  • Home
  • VIP Access
    • Log In
    • Manage VIP Account
    • Register for VIP Plan
    • VIP Member-Only Content
  • Blog
  • About Us
  • Technical
    • HCM Data Loader
    • HCM Extract
    • BI Publisher
    • Fast Formula
    • Security
    • OTBI Analytics
    • Personalizations
    • Scheduled Processes
  • Functional
    • Core HR
    • Absence Management
    • Payroll
    • Benefits
    • Performance Management
    • Talent Management
    • Time & Labor
    • Helpdesk
    • Learning
    • Recruiting
    • Onboarding
  • Interview Tips
    • HCM Extracts Questions
    • HCM Data Loader Questions
    • BI Reports Questions
  • Log In
    • Generic filters
      Exact matches only
      Search in title
      Search in content
      Search in excerpt
Don`t copy text!