I am trying to change column name in SQL but it is showing me error query alter table cust rename column first name to first_name(30) ; error ERROR: syntax error at or near "name"LINE 2: rename column first name to…
I have page item in my Interactive Grid (IG) that dynamically updates the row count using a model subscription. When a new row is added, the count increases, and if a row is marked for deletion, the count decreases by…
I Need your help for connect Oracle in PHP. Using Red hat server 8.9 , PHP version is 8, OCI8 is enabled, HTTPD web server installed. Whatever steps required i did like, > /etc/httpd/conf/httpd.conf SetEnv LD_LIBRARY_PATH /home/oracle/Avani/dbhome_1/lib SetEnv NLS_LANG American_America.UTF8…
I need to parse JSON using Oracle SQL select. Here is my JSON: {"result":[ { "field_name1":{"display_value":"TEST1","link":"https://test1.com","value":"abcd"}, "field_name2":{"display_value":"","link":"","value":""}, "field_name3":{"display_value":"TEST3","link":"https://test3.com","value":"efgh"}, "field_name4":{"display_value":"TEST4","link":"https://test3.com","value":"ijkl"} } ]} I want to get results as follows: field_name1:abcd field_name3:efgh field_name4:ijkl excluding those that have nulls in the value. How…
The issue when I don't use AGG type I get a 'ora-01422: exact fetch returns more than requested number of rows using a json_object put into clob so using JSON_ARRAYAGG works I just haven't been able to figure out how…
I have a JSON like this, stored in a CLOB column: { "code": 1, "required": [ { "field": "R1", "value": 1 }, { "field": "R2", "value": 2 } ], "optional": [ { "field": "O1", "value": 1 }, { "field": "O2",…
Why this: with j(jval) AS ( select JSON_SERIALIZE('{"contract" :{"contract-type" : "P", "contract-id" : 123451, "proposal-no" : "123456", "serial-no" : "serialasd922", "product-code" : "s093", "contract-sign-dt" : "2016-12-01T00:00:00", "contract-start-dt" : "2016-12-09T00:00:00" } }' pretty) from dual ) SELECT json_transform(jval, insert '$.contract[*].x' =…
This answer is for the simple JSON type. PLSQL looping through JSON object I have a complex JSON type how do i loop thru a data like this. Is there any oracle function which traverses this complex type? [[{"PONumber":1,"ItemNumber":1,"Part":{"Description":"Tora! Tora!…
I'm currently struggling to import my API-Response to my Oracle table. I'm using the JSON_TABLE() but this function is not working as expected. I have a JSON value like this: { "CAR-1": [ { "state": "waiting", "timestamp": 1720476000 } ],…
I have a spring boot application running as docker container on my local machine. It is connecting to Oracle database which is there on our company datacenter. I am able to connect to database directly from my local machine using…