I am trying to pass a large number of records as a stringify object from client to the server. In the server side there is a function called 'Get_Records' to capture that string object. Then it should parse the string…
When I run the below SQL query in Oracle db, the value is returning even though where clause is failing, how to avoid this issue? SELECT '{"load_invoice":' || JSON_OBJECTAGG(KEY 'Module' VALUE 'AR') || '}' FROM dual WHERE 1 = 2;
Is there a way to make this Oracle query more optimal? Ideally without selecting from the same JSON_TABLE twice. SELECT to_dncl_verification(status_code => t.status, d_valid_from => to_date(t.d_valid_from, 'yyyy-mm-dd'), d_valid_to => to_date(t.d_valid_to, 'yyyy-mm-dd'), category_list => CAST( MULTISET (SELECT tc.category, CASE WHEN tc.allowed…
Within a table (prov) in my database, I have a column (data_json) of type BLOB that contains data of type JSON. The JSON structure has two types (can be more but now only two). For the current two types, I…
I am working with python oracle connection. But i have a issue returning date with the cursor result as json. below is the json result of the cursor, the issue is format of create_dttm. When creating a dataframe from this…
The code looks like this: SELECT JSON_OBJECT( ROOM_LIGHT VALUE JSON_OBJECT ( 'START' VALUE START, 'ENDE' VALUE ENDE, 'RUN' VALUE RUNNING ) ) FROM runtime WHERE 1 = 1 GROUP BY ROOM_LIGHT; I want this JSON back: { "ROOM_LIGHT": "01": […
For our new MySQL database, we are thinking of using UUID as the primary key stored as BINARY(16). The key values would be generated by the the below function in Java application, or by UUID_TO_BIN(UUID()) built-in functions in data loads…
I have a problem with connecting (actually at the pre installing step) Informatica to the Oracle DB running on Docker. Because of my lack of experience and also knowledge I don’t know what may be the problem. Has anyone had…
SELECT AL1.ACCOUNTING_PERIOD, AL1.BUSINESS_AREA, AL1.SAP_ACCOUNT, AL1.ID, AL1.USD_AMT, AL1.BAN_NBR, AL2.CUST_NBR, AL2.CUST_NAME FROM DSL_AIM.AIM AL1, DSL_AML.AID AL2 WHERE ( ( AL1.ACCOUNTING_PERIOD_CD IN ( '2023-02' ) GROUP BY AL1.ACCOUNTING_PERIOD, AL1.BUSINESS_AREA, AL1.SAP_ACCOUNT, AL1.ID, AL1.USD_AMT, AL1.BAN_NBR, AL2.CUST_NBR, AL2.CUST_NAME HAVING COUNT(*) = 1; I get a different…
What's the easiest way to implement following solution: There is an old legacy app which uses Oracle DB, the idea is to create a new service in SpringBoot which would observe for changes on a few specific tables in this…