Writing Annual Leave Reconciliation Form Query with Oracle HCM Cloud Sql
Calculated from the ANC_PER_ACRL_ENTRY_DTLS table from the Accrual For Progress Payments table. Records with Type ‘FLDR’ are selected.…
by Kaan Can Calkan January 1, 2024
by Kaan Can Calkan January 1, 2024
Oracle Dependent Parameter Example
After writing my main query here, I defined my parameters by placing them inside the NVL functionSELECT PPNF.FIRST_NAME,PPNF.LAST_NAME,PPNF.FULL_NAME,PAPF.PERSON_NUMBER,TO_CHAR…
by Kaan Can Calkan December 15, 2023
Adding Parameters to Oracle Cloud Report
I am adding parameters to my SQL query. When adding parameters, I use NVL. NVL (Null Value) is…
by Kaan Can Calkan December 12, 2023