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…
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…
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…
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…
I'm working with APEX ORACLE ver 23.1. In an interactive grid, I have a column for selecting values and saving them in database. I set that column to type Popup LOV. The source of LOV is a SQL query in…
I have a need to generate a three level nested JSON payload out of Oracle tables. I have described two approaches I have used to accomplish this and neither of them work. Please advise where am I going wrong! Approach…
I have the following result of a query: P2_AU_CE P2_03 P2_AU_CE P2_04 P2_CN_MOCE_001 P2_04 I would like to have the result shown this way instead: P2_AU_CE P2_03 P2_04 P2_CN_MOCE EMPTY P2_04
I try to get information from a JSON file, described in the following select statement. This works in Oracle 19 and also on Oracle 12.2.0.1 with xmldata as ( select '{ "metaData": { "validForClearingDay": "2022-11-16", "createdStamp": "2022-11-15T16:30:17.329433+01:00" }, "entries": […
I have a transactional database with more than 100 columns. Now if I have to select all the rows but only those columns which have changed down the table (more than one distinct value for a particular column). how can…
I have php project running on php version 8.1, installed on locale server ubuntu 20.4, in the server there is oracle 9i, Ive instlaled oracle instant client and im trting to connect php project to oracle db, i want to…