I have two web application and Oracle servers. Web application server has the following details: Linux server (LAMP) oci8 PHP 7.4 Oracle Database server has the
This is just a dummy example. In reality I have a foreign key which references a lot of more columns. That why I'm trying replace the normal join with a "natura
I'm currently trying to create a CD pipeline with Azure DevOps with a solution using .NET Framework 4.8 and Oracle. Unfortunately, I can't make it run; as the D
Getting the following output when i use the below query SELECT P.RefNum ,Ian.ID ,Ian.Date ,Igl.Name ,Ian.Comments ,ROW_NUMBER() OVER (
I had a SQL SELECT dtl.ACCT_YM AS ACCT_YM, src.SRC_NAME AS SRC_NAME, ptnr.PTNR_NAME AS PTNR_NAME, info.P
As title, I'm writing some Stored Procedure on Oracle, first I checked the version SELECT * FROM v$version; with result Oracle Database 11g Enterprise Editi
Problem : I have a view which was significantly slower earlier(fetching 50 records took 25sec) Made some code changes and performance increased by a lot( 50 re
I am having table like this, where id is repeating several times. I need to get only max L1 value for each ID, so correct result from the que
We are updating an older application to use the "new" Oracle.ManagedDataAccess instead of the locally installed Oracle Client. But since then a simple statement
in relation with how to copy the records from output of oracle SQL developer to excel sheet I'm using Oracle SQL developer. I've some queries which get some nul
I have a small asp.net core 2.2 app that should access an oracle db; I'm using NuGet Oracle.ManagedDataAccess.Core (2.18.6), and it just works on my machine. W
I am writing this code which throws an error in primary key: DECLARE CURSOR A1 AS SELECT TRANS_DET_ID, (SELECT MAX (NVL(TRANS_DET_DET_ID, 0
I'm converting my total amount into words using bi publisher. Btw, the amount is base on the data from the data set. Can someone help me what to do? Thanks <
I want to write a programm that first checks if a column is only populated with NULLs before updating the column. I have written what I thought should work, how
Trying to execute a procedure in perl script, Proceure ->create or replace PROCEDURE Getproc ( v_catg IN CHAR DEFAULT NULL, v_cursor OUT SYS_REFCURS
I have sample data like this CREATE TABLE table_name (aktif, "START", "END", NO_BOX, QTY) AS SELECT 1, 'A0001', 'A0020', 2016, 100 FROM DUAL UNION ALL SELECT 1,
I have a table, it's going to be used for a supplier scorecard, with eleven different fields that can be assigned a value of 1-5. Null values are allowed. I
There is a date column used in OBIEE analysis. That column is declared as 'date' datatype in Oracle table, type in rpd is also 'DATE'. However, when exported to
Using Visual Studio 2017 and SSIS. Basic data flow from Oracle to SQL Server. Oracle is source (OLEDB) and SQL Server is destination (OLEDB also). I'm using
I am using oracle DB. I have a Aggregated script. We found that some of the rows in the table are repeated, unwanted and hence, is not supposed to be added in