There is a source table which loads the data full and monthly. The table looks like below example. Source table: pk code_paym code_terms etl_id 1 2 3 2020-08-01 1 2 3 2020-09-01 1 2 4 2020-10-01 1 2 4 2020-11-01 1 2 4 2020-12-01 1 2 4 2021-01-01 1 2 3 2021-02-01 1 2 3 2021-03-01 1 2 3 2021-04-01
Don’t save info in table
I am trying to save the information to the database in the following way: But I get the following error: Using next data: UPD: Check for data and types, get next UPD2: If I use next code, it’s work: But I want to change table Answer Issue resolved, it works:
C# invalid column name problem but is different from others
Hello i have a table called Card_tbl with a cell CardID. The problem is that when i insert only numbers like 12345 they are uploaded in the database, but when i use mix letters like Q1234R it will say INVALID COLUMN NAME Q1234R I tried many things to fix it but no success. THE CELL IS ON VARCHAR(50) this is
Adding elements in the end to a json array of objects in Oracle
I have a json column named “configuration” in an Oracle database with a data like- How can add elements to the “sections” array inside the CLOB? for example, add this object to the CLOB- {“active”:false, “code”:”page.body”} I tried to do this- but I got this error- Error report – SQL Error: ORA-00917: missing comma 00917. 00000 – “missing comma” *Cause:
About Containers scalability in Micro service architecture
A simple question about scalability. I have been studying about scalability and I think I understand the basic concept behind it. You use an orchestrator like Kubernetes to manage the automatic scalability of a system. So in that way, as a particular microservice gets an increase demand of calls, the orchestrator will create new instances of it, to deal with
Undefined filter parameter in Hibernate
I am trying to map a LocalDate to a SQL Date, but am receiving this error: java.lang.IllegalArgumentException: Undefined filter parameter [afterDateLocal] I can’t provide a reproducible example, but here’s the code of the ListingRepositoryImpl: And the filters defined on the entity listing: I am using Hibernate 5.5.7 so I expect LocalDate to work. Answer date was not defined in the
Keep variables in the SELECT list which are not used in the GROUP BY nor aggregated
I have 2 tables: table1 (including id, title, and abstract) and table2 (including id, pubdate, and family_id). Each id is unique but multiple rows can have the same family_id. My goal is to display the id, title and pubdate only for the MIN(pubdate) of each family_id so that I should get: I tried this: I get the following error message
How to return results from a subquery greater than a value
I’m trying to find measuring component ids that show up at least 3 times. At this time it is throwing the Oracle Error “ORA-00936: missing expression.” I have tried putting in an existing statement to possibly satisfy the missing expression error, to no avail. It either returned too many values or didn’t bring back any values at all. How do
Calculating daily volumes from total volume
I have the following data: ID Date Total A 2021-09-03 0 A 2021-09-04 12 A 2021-09-05 37 A 2021-09-06 40 B 2021-08-03 20 B 2021-08-04 43 B 2021-08-05 75 And from this data, I would like to get the following table: ID Date Total Daily A 2021-09-03 0 0 A 2021-09-04 12 12 A 2021-09-05 37 25 A 2021-09-06 40
How to group rows by the date part of a timestamp column?
There is a table having timestamp column : I want to get all rows and the sum of the duree_seconde column based on the date part of the connexion column ; that means I want to sum all the duree_seconde column values for each same day, for example if there are data like this : how can I get the