Questions tagged [json-table]
The json-table tag has no usage guidance.
json-table
23
questions
1
vote
2
answers
41
views
JSON_TABLE()-Function in Oracle's SQL
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": [
...
0
votes
1
answer
32
views
Oracle SQL JSON_TABLE PATH references in some columns returning next record (+1?) child data elements
I am working for the first time with .JSON data stored in a Oracle DB (BLOB) column, and an having issues with getting my SQL query to render data as desired. This is also my first time using ...
0
votes
0
answers
21
views
Create mysql table from json string when 1st dimension hold columns and 2nd dimension holds rows
I am sitting with a legacy database and im trying to create this table in mysql using json strings stored in the database.
I have a table that stores a massive json string and one of the keys inside ...
0
votes
2
answers
115
views
IBM Db2 Query Not Returning Expected Results for JSON Array Objects
I'm working with IBM Db2 (Version 11.5) and I'm trying to query JSON data stored in a column named data which contains an array of objects. However, my query using JSON_EXISTS does not return the ...
0
votes
1
answer
23
views
CROSS JOIN JSON_TABLE with REGEXP_REPLACE and LOCATE not giving the correct result
I have a table with a column named tags. In this column, I have a comma-separated list like отказвам резервацията, отмяна на резервацията, etc.
My query looks like that:
SELECT * FROM products
CROSS ...
0
votes
0
answers
12
views
How can I add json_table in to createQueryBuilder (typeorm) [duplicate]
I tried to run:
return this.myRepository
.createQueryBuilder('s')
.select(['s.add', '_id'])
.innerJoin(
`JSON_TABLE(
json_field,
'$[*]'
COLUMNS (
...
0
votes
1
answer
36
views
Joining a Json attribute with Oracle Database column to get matching rows using JSON_TABLE - Oracle 19C
This is on Oracle 19c Database.
I have a need to develop a DB view containing a traditional relational table and a json_table and only get filtered row based on a column from this relational table ...
0
votes
2
answers
63
views
How to convert a json array to relational data in oracle
I have the following json array that is a part of a json file that I am trying to convert to relational data in Oracle using the json_table function:
{ "Id" : "XXX000",
&...
0
votes
1
answer
186
views
Get value from JSON Array List in DB2
Below is example kind of data. Is there any way to get value only id from below json array.
Env: DB2 query TABLE NAME: RTN_PRD COLUMN NAME : DTL_PRD
{"ProductList":"[{\"ID\":...
0
votes
0
answers
37
views
Using JSON_TABLE to save an unorder ARRAY
I have the next array, I need to save in a json_table, the problem They are shown in different order for each employee For that reason I can't store using:
Depto varchar(100) path '$.plaza....
0
votes
0
answers
82
views
mysql: Invalid JSON text in argument 1 to function json_extract: "Invalid value." at position 3333
I need to save the next data in a json table:
[
{
"company": 2,
"employee": {
"payroll": 1,
"id":130434
}...
0
votes
1
answer
81
views
Oracle returns invalid number of rows on json_table
When I run following query on Oracle 19, it returns 28 record instead of 30, and I cannot understand why, as I am expecting 30 records:
select *
from json_table('{"values":[[1,120674124,...
0
votes
1
answer
187
views
Extract JSON array values with generic keys to JSON_TABLE in uniform columns
I have JSON that is being brought into MariaDB/MYSQL database via Airbyte from a API query. I am using JSON_TABLE to break the JSON into columns - which is mostly working great, but I just noticed ...
0
votes
1
answer
54
views
Complex Json file and Oracle JSON_TABLE results in more than one row
I have a complex Json file (in a CLOB). I'll try to make it esential:
{
"c1": "c1",
"c2": "c2",
"c3": {
"a": "a"
},
&...
0
votes
1
answer
65
views
MySQL8 json payload does not accept json string as value for element
I have a stored procedure (see stored_procedure_1 code below) that expects json passed as an argument and inserts that data into a table.
-- stored_procedure_1:
DELIMITER \\
DROP PROCEDURE IF EXISTS ...