oracle Questions

php OCI8 install on docker

October 18, 2023
Fpasquer
2 Answers

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…

VIEW QUESTION

Mysql – Need a Specific row in between another row in SQL

October 13, 2023
Harish
3 Answers

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…

VIEW QUESTION

Postgresql – Split a row into columns in SQL

October 5, 2023
Coder
2 Answers

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…

VIEW QUESTION

Using html expression in LOV in APEX Oracle

September 29, 2023
Tien
2 Answers

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…

VIEW QUESTION

Generating deep nested JSON palyload out of Oracle SQL

September 19, 2023
virtual transfer
2 Answers

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…

VIEW QUESTION

Mysql – Divide results of a query in two different columns

September 18, 2023
Cristina Biagiotti
3 Answers

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

VIEW QUESTION

What is the correct way to select nested information from a JSON file in Oracle 12.1.0.2?

August 31, 2023
Hanspeter
2 Answers

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": […

VIEW QUESTION

Mysql – How to select only those columns which have some changes ( more than one distinct value)

August 28, 2023
Notacoder22
2 Answers

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…

VIEW QUESTION

Php versions – Connect Oracle with PHP

July 21, 2023
Ahmed Al Omari
2 Answers

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…

VIEW QUESTION

Oracle 19C Query with hierarchical JSON

July 12, 2023
JShao
2 Answers

I have 2 Oracle tables table_1: ID target_id name url 1 A John example.org 2 B Jane helloworld.com table_2: id1 target_id col1 col2 X A aaa bbb Y A ccc ddd I am trying to run query joining table_1 and…

VIEW QUESTION