Performance issue with query getting audit information
Jan 12, 2023 · The I/O from this query is incredibly high. Please see attachment for SQL monitoring snapshot. Since the general best practice suggested by Oracle is to not disable …
Concatenate Date values with Presentation Variable
Dec 24, 2021 · Hi All, I have created a dashboard prompt with 1 presentation variable date prompt (Start date) showing First day of quarter and few column prompts in a dashboard.
Autonomous Database and timezone — Cloud Customer Connect
Nov 27, 2019 · Summary how to change a timezone in an Autonomous Database Content i use the parameter TIME_ZONE but the value don't change Oracle Database 18c Enterprise …
User All Login Details within a specific period
Dec 2, 2024 · Hello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details.
Report to fetch Element with assignment number and name for …
Nov 9, 2021 · Summary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details.
SQL Essentials: TO_CHAR Function Explained — NetSuite Community
May 22, 2025 · Overview TO_CHAR is an SQL function that converts a date, time, or numeric value into a formatted string. It allows you to customize the display of these data types …
Need to know approval date file & table name of absence records ...
May 20, 2023 · Summary: we use oracle fusion cloud.Need to know approval date file & table name of absence records attached my sql, if anyone please mo
Sql Query to fetch details of offer creation in Oracle Recruiting Cloud
Oct 4, 2024 · Hi Team, I am currently encountering an issue with an SQL query. It appears that the query is returning multiple assignment numbers for candidates who have Moved to HR in …
Hi all, An App engine process is getting stuck at "processing" from ...
Nov 1, 2019 · Hi all, An App engine process is getting stuck at "processing" from long time. when checked db logs found that an session is inactive with below sql:
SQL to get Absence Enrollment details for Person
Oct 24, 2023 · SQL to get Absence Enrollment details for Person Version (include the version you are using, if applicable): 23C Code Snippet (add any code snippets that support your topic, if …