I am trying to replicate a function from Oracle that has the following piece of code OPEN pcursor FOR v_sql; loop fetch pcursor into out_rec.XYZ ; exit when pcursor%NOTFOUND; INSERT INTO tab1 VALUES (out_rec.XYZ); COMMIT; pipe row(out_rec); end loop; EXCEPTION…
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…
I hope I'm in the correct forum. I desperately try to create an docker image with an oracle database that runs on my raspberry pi. There are some resources in the web with an step by step guide how one…
{ "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"}, {"property_id":6,"property_name":"Axle","value_id":62,"value":"Front / Rear Right"},…
``` select JT.* FROM JSON_TABLE (json_sample) '$.general[*]' COLUMNS ( product_key NUMBER PATH '$.product_key', group_subtype_id NUMBER PATH '$.group_subtype_id', group_subtype_name VARCHAR2 ( 100 ) PATH '$.group_subtype_name', variant_id NUMBER PATH '$.variant_id', variant_name VARCHAR2 ( 100 ) PATH '$.variant_name', rb_customer_id NUMBER PATH '$.rb_customer_id', NESTED…
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 am currently engaged in learning to formulate queries on the Datalemur platform. Upon encountering a specific question, I diligently crafted a solution which successfully yielded the desired output. Regrettably, despite achieving the intended result, my solution failed to meet…
I want to create a operational data store in mongo database. The source data is available in oracle database.The problem is while migration there are chances, where the data in source db may get updated. How can i reconcile between…
I use this code to record a JSON datas to a Oracle Database SELECT NOM, PRENOMS, DATE_NAISS FROM JSON_TABLE('[ { "Id": 123, "Nom": "Toto", "Prenoms": [ "Pascal", "Vincent" ], "DateNaissance": "1983-01-01T00:00:00" }]', '$[*]' COLUMNS ( "NOM" PATH '$.Nom', "PRENOMS" PATH…
I am following this tutorial here and I have my docker image running. It was created with docker run -d --name test19c -e ORACLE_PASSWORD=Oracle_2023 -e APP_USER=scott -e APP_USER_PASSWORD=tiger -p 1521:1521 oracle/database:19.3.0-ee Then I am trying to run SQL with conn…