I've been given access to an Oracle Server via ODBC and tested the connection using Oracle SQL Developer. These are the connection constants I've set in PHP: define('APP_DB_HOST', '192.168.1.1'); define('APP_DB_PORT', '1521'); define('APP_DB_USER', 'MyUser'); define('APP_DB_PASS', 'MyPass'); define('APP_DB_SID', 'MyDatabaseSID'); define('APP_DB_SCHEMA', 'MyDatabaseSchema'); With…
A table has JSON data in the HUGECLOB column. And I want to parse it. How can I do it? {"errors":{"destination_country_id":["can not be blank"],"dispatch_country_id":["can not be blank"],"vehicle_id":["can not be blank"],"trailer_id":["can not be blank"]}} I tried this; SELECT t.* FROM table,…
In a XML like this: <item> <id>1</id> <name>ITEM 1</name> <subitems> <item> <id>2</id> <name>SUBITEM 1</name> <subitems/> </item> <item> <id>3</id> <name>SUBITEM 2</name> <subitems> <item> <id>4</id> <name>SUBITEM 3</name> <subitems/> </item> </subitems> </item> </subitems> </item> There can be several levels of subitems in the…
I have CLOB field with JSON data : [ { "name": "Rahul", "LName": "Sharma", "salary": "20000", "Age": "35" }, { "name": "Kunal", "LName": "Vohra", "salary": "10000", "Age": "25" } ] and I need update value in only one element of…
Have a project for work & my SQL skills are improving, but I still struggle with basic stuff every now and then. I need to get 'fundingCode' to show up as a string rather than a number as it is…
I have one of the column audit_info with JSON data in the table: { "AddInfo":{ "UPN":"[email protected]", "UserName":"[email protected]", "TimeStamp":"2021-10-11T15:54:34:4805634Z", "Source":"xyz" }, "ChangeInfo":{ "UPN":"[email protected]", "UserName":"[email protected]", "TimeStamp":"2021-10-11T15:54:34:4832421Z", "Source":"xyz" } } I need to update TimeStamp of seconds decimal point from :4832421Z to .4832421Z…
I'm using Oracle 19c and was wondering if you could take a JSON object like this... { "Employees": [ { "EMPLOYEE_NUMBER": "XXX-XX-XXXX", "FIRST_NAME": "John", "LAST_NAME": "Doe", "TAX_YEAR": "2022" }, { "EMPLOYEE_NUMBER": "XXX-XX-XXXX", "FIRST_NAME": "John", "LAST_NAME": "Doe", "TAX_YEAR": "2021" } ]…
I have a couple of questions on AWS RDS service for migrating an oracle 19c server on RHEL with 3 standalone instances and databases: Can RDS instance support multiple oracle standalone instances/databases or only one instance? If I have an…
I created a container for an Oracle Express database following these instructions, with the following command: docker run -d -e ORACLE_PWD="root" --name testdb -p 5500:5500 -p 8080:8080 -p 1521:1521 container-registry.oracle.com/database/express:21.3.0-xe What does work I managed to access the database from…
I have what is probably a remedial question, but I am struggling to come up with the best way to implement it through searching. I am working on a retool workflow that will get the latest shipped sales orders, and…