I am migrating some data. I have a table data which has quite a lot of columns to reference other tables. And those other tables are being changed and simplifie
I have an application created using .NET Core 3.1 which needs to connect to an Oracle database, the connection code is very straightforward and I'm connecting u
I am trying to query data from linked server. It is giving me the following error: TNS:listener does not currently know of service requested in connect descrip
I'm planning to write a pl sql pseudo code procedure a gets all records from emp and is passed to procedure b procedure b getting called inside from a , is tra
I'm working on Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production and I need to develop a store procedure that access an API, I have t
select case when code = number_1 then number_1=code when count(code)>=count(number_1) then number_1 = sum(code)
I'm running below code and getting below results but I want to remove ,, and after ,, texts from email address and that email address should show in UPPER(PT_PA
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 <