Do not use quotation marks with character and date items.
• The LIKE operator is implied with % or _.
• Use hash (#) in front of SQL operators.
• Use Query/Where for complex query conditions.
• Use default date format (DD-MON-YY) in Query/Where.
• Use quotes around literals in Query/Where.
Oracle HCM & ERP insights from the field — Fusion Cloud, Redwood UI, Payroll, Absence, BIP, OTBI and integrations.
Subscribe to:
Post Comments (Atom)
Oracle HCM AI Agents: Real-Time Leave Analytics & Smart Employee Workspaces — Live on Fusion HCM
🔴 Oracle AI Agent Studio · Case Study Oracle HCM AI Agents: Real-Time Leave Analytics & Smart Employee Workspaces — Live on Fusion HCM ...
-
While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS go to propert...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
-
Let us assume that we are going to register a report. E.g:- Customizing seeded report: 1.Copy the rdf for the module top. 2.open it ...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.