We are using a proprietary product to develop our application. This product is capable of connecting to Oracle DB and executes SQL queries and stored procedures
I want to connect from my codebase which is console C# project to an Oracle database. I am using Entity Framework Core 6.0: using Microsoft.EntityFrameworkC
SQL table: CREATE TABLE Application ( App_ID number(5), Child_Name varchar2(15) CONSTRAINT pk_Application_App_ID PRIMARY KEY, Child_Weigh
I have tables like this: table 1: FNAME ID1 FID BREAD XYZ 18BREAD FISH ABC 45FISH BREAD_OLD BNQ 18BREAD_OLD BACON TBG 77BACON EGGS CGS 99EGGS BANANA BHG BANANA
I am having a csv file which contains 0 in timestamp column in source , when it is being inserted into oracle through informatica it is populated as NULL values
First time I am using .net6 with entity framework trying to call stored procedure. CREATE OR REPLACE PROCEDURE get_registration ( IDIn IN Number DEFAULT nu
I want to retrieve multiple sys_refcursors from oracle db using dapper. My PL/SQL code below procedure GetData2 (p_result out sys_refcursor, p_result2 out sys_r
Can't understand why Oracle did not fire any DDL trigger. >SELECT * FROM V$VERSION Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Exam
I'm trying to extract ID values where End_Time for type A is not equal to Max End_Time of each System_Id ID System_Id Type End_Time 1 1 A
I have a table with thousands of rows. One of the columns does not read the values correctly. Some letters cannot be recognised and thus changed to some symbols
We just upgraded one of our database servers from Oracle 12.2.0.1 to 19.15.0 and one our perl programs is behaving differently. We are running with RedHat 8.4 u
I have multi-part SDO_GEOMETRIES in Oracle 18c. I can extract the parts as individual rows using the SDO_UTIL.EXTRACT_ALL() function: with cte as ( --Each part
So, I'm not sure how it works and I haven't found a sufficient answer by googleing (probably not using the right buzz words). So here it comes: Let's say I have
I have following Oracle SQL code: SELECT TO_NUMBER(TRIM(REGEXP_REPLACE(per_growth, '(%)(\s)')), 'FM99999999999999999990D099999999999999999',
I've data like below Id date time type 1 01-01-2022 08:00 in 1 01-01-2022 11:30 out 1 01-01-2022 11:35 out 1 01-01-2022 12:45 in 1 01-01-2022 17:30 out 1 01-01
I have several environments where we have implemented sqlcl and apex versioning. Oracle database 19c - SqlCL version 20.3 The only difference versus other envir
I have downloaded and installed Oracle DB EX 21c on Windows and it seems the only way to interact with it is using the command prompt. Some older versions like
WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested Oracle
I have a table and I want to increment a column by 1 when I insert a row into the same table. Table users - when I insert first row value of idusers is 1, and i
I would like to know that is there any other effective way or query to get the desired output for the below query with AND operators because if I run this below