Postgresql – Ranking by groups of continuous equal values
With this query: with tbl as ( select 1 ord, 'A' name from dual union all select 2 ord, 'A' name from dual union all select 3 ord, 'A' name from dual union all select 4 ord, 'B' name from…
extracting and inserting data from JSON in Oracle
I have one JSON file and I´m trying to insert in database. Inserts are not working, not sure if I am looping correctly json I´ve done a very easy example: This is the table: CREATE TABLE TEST ( remote_claimid VARCHAR2(20)…
Sum values of JSON array in oracle sql
I have a Table which contains data like id, country, city,capacity. Capacity is a JSON array field which has values like [{'totalCapacity':100.0},{'totalCapacity':90.0},{'totalCapacity':80.0},{'totalCapacity':80.0}] against a row in table, so row in table looks like id country city capacity 1 usa new-york…
Javascript – Oracle Apex – Is it possible to send a value from a page item from the client side to the server side without a submit?
I added a JavaScript function to capture the ROWID of the rows that are selected in the GRID and passed it to a page item. var gridView = apex.region("emp").call("getCurrentView"), selectedRecords = gridView.getSelectedRecords(), idValues = ""; for (var i = 0;…
Asp.net – Split dt column values for accepting only month and year in C#
I have a DataTable column which has values like 01-04-2023 00:00:00. I want only 04-2023 from that column and update in new DataTable. How can I split that in DataTable? Dt has that column with name DATA_WITH_MONTH_YEAR. update Below is…
python-oracledb module fails to use instantclient in a docker container
I'm trying to build a docker image to access an oracle database at runtime, I'm having the following error message: DPI-1047: Cannot locate a 64-bit Oracle Client library: "/oracle/instantclient/libclntsh.so: cannot open shared object file: No such file or directory". Inside…
Json – How to get a value based on a key from KeyValuePair data stored in one cell in oracle database
lets say i have a table like that id name address Doc 1 {1:mark,2:john} {1:Home,2:Work,3:Club} {NI:299,Pass:A159} 2 {1:Max,2:Mo} {1:Home} {NI:300011} what i want is to write a qurey to select a value from cell based on the key for example…
php OCI8 install on docker
Hello I have a really simple dockerfile who is the following: FROM php:8.2-fpm ARG URL_INSTALL_CLIENT_BASIC='https://download.oracle.com/otn_software/linux/instantclient/2110000/instantclient-basic-linux.x64-21.10.0.0.0dbru.zip' ARG URL_INSTALL_CLIENT_SDK='https://download.oracle.com/otn_software/linux/instantclient/2110000/instantclient-sdk-linux.x64-21.10.0.0.0dbru.zip' RUN apt-get update RUN apt install -y unzip curl RUN mkdir /opt/oracle RUN curl ${URL_INSTALL_CLIENT_BASIC} --output /opt/oracle/instantclient-basic-linux.zip RUN curl ${URL_INSTALL_CLIENT_SDK} --output /opt/oracle/instantclient-sdk-linux.zip RUN…
Mysql – Need a Specific row in between another row in SQL
I have a below Organisation table. ID Resource 1 Software Engineer 2 Tech Lead 3 Architect 4 Senior Software Engineer 5 HR I need to fetch this table using select query such that the output which i receive should have…
Postgresql – Split a row into columns in SQL
E1 E2 E3 EXPLANATION AMOUNT 01 PERSONNEL EXPENSES 5000 01 1 OFFICERS 5000 01 1 1 BASIC SALARIES 3000 01 1 2 INCREASES AND COMPENSATION 2000 02 GOODS AND SERVICES PURCHASE EXPENSES 8000 02 1 SERVICE PROCUREMENT 8000 02 1…