v19.22 Requirement is to run some queries against the audit table at the beginning of the month to capture details about the previous calendar month. EVENT_TIMESTAMP in UNIFIED_AUDIT_TRAIL is timestamp(6) (not date) Is this an appropriate where clause to query this view? Or is th...

Hi Tom, i have a question about the index fragmentation, on the famous white paper "How to stop defragmenting and start living: the definitive world of fragmentation" by Bhaskar Himatsingka and Juan Loaiza, on section 4.2, they provide a script to tell if the index can reduce a b...

now i have json response from oracle service like following code { "Status": null, "RequestNumber": null, "validationResults": [ { "code":E1000, "details":'Validation Error' } ] } now i can read keys Status and request numbe

I'm trying to follow along with the live lab 'Build a 'Doctor Appointments Made Easy' App using Oracle APEX Introduction' to get to know the new Workflows in Application Express. In Lab 9 task 6 I run into an error in the Check Appointment Fee activity: ORA-01843: not a valid mon...

Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me know how can I share...