I am in the process of migrating from Oracle to Postgres with Ora2pg but I find this problem that the signatures on the Postgres side do not exist can you help me find the right solution ? What will be…
select JT.* FROM JSON_TABLE ('{ "general": { "product_key": "501088", "group_subtype_id": 1, "group_subtype_name": "Wheel Speed Sensor", "variant_id": 6, "variant_name": "DF22", "rb_customer_id": 287383 }, "partnumbers": [ { "partnumber": "F04FD009BD", "pn_type": "Series OEM", "mat_status": "00 - planned", "properties": [ {"property_id":4,"property_name":"ASIC P/N","value_id":38,"value":"8905502648"}, {"property_id":5,"property_name":"ASIC type","value_id":56,"value":"TLE4942"},…
I'm writing a function in oracle 19c, which should, on given json_object_t that can have any structure, loop through all the keys, and if key is one of pre-specified, mask the value with asterisk. Those values would be card numbers.…
I have below JSON I want to Read all fields from 65300, 230935, 231832 objects which are under discountDetail objects. Problem is 65300, 230935, 231832 objects are dynamic and are not known in advance. These are ids which are created…
I have a couple of tables which have information about an activity(like an article), how do I get a column back that spits out a value based on some condition Learner Certificate view dt First 2023-10-09 Second 2024-01-03 Learner Certificate…
Hi I am working in Postgres. I have below code DO $$ DECLARE item integer; begin item:=5; DROP TABLE IF EXISTS temp_data; CREATE temp TABLE temp_data AS select current_timestamp + interval '1 day' as op; END $$; select * from…
Using oracle plsql, please tell me how to use JSON_TABLE, bfilename and "bulk collect" in order to read data from a json file. The json file contains 2 lists of strings: { "included_errors": [ "include1", "include2" ], "excluded_errors": [ "exclude1",…
I added a JavaScript function to capture the ROWID of the rows that are selected in the GRID and passed it to a page item. var gridView = apex.region("emp").call("getCurrentView"), selectedRecords = gridView.getSelectedRecords(), idValues = ""; for (var i = 0;…
I have a need to generate a three level nested JSON payload out of Oracle tables. I have described two approaches I have used to accomplish this and neither of them work. Please advise where am I going wrong! Approach…
I need help with understanding and fixing the following issue. I have created a postgresql function for retrieving all events in a specific regions based on regions like this: CREATE OR REPLACE FUNCTION get_all_events_in_regions(regionIds int[]) RETURNS SETOF events AS $$…