I have 2 Spring Boot applications let's say named App1 and App2. There is a table in oracle DB with status column. when App1 runs a scheduler, it will update t
I have an Oracle stored procedure I am trying to execute in SSIS Execute SQL Task. This stored procedure involves refreshing materialized views. For each and ev
I have a logic where doing some calculation like below is giving error as ORA-01476: divisor is equal to zero I have added CASE condition like below V_EFFEC_P
i need help with this question, Using PL/SQL how can I read a string backwards using the while loop? I know that with the for loop there is a
I created my first Autonomous database "Always Free" on OCI. The provisioning have gone well and the db exists in my compartment. However, when I click on "DB A
I have a query some times I get timeout exception and query runs on the backend for ever not displaying any information and causes application to hang up how ca
I run a simple query with oracle database 11g on CentOS, but I got wrong CHARACTER SET. SQL> select col_name from table_name where rownum <= 1; col_name
I'm using oracle 11 XE & Application Express 4.0.2.00.09 and I have this function that I want to print it's cursor. I don't know how to read the return of t
I have an interactive report and the goal is to let the user export the data but without 1 column. What I tried for the column in question: 1) Server-side condi
CREATE OR REPLACE TRIGGER PEN_DELTA BEFORE INSERT ON PS_GP_RSLT_DELTA FOR EACH ROW WHEN (NEW.FORWARD_IND = 'Y' AND NEW.GP_PAYGROUP = 'PG PEN') BEGIN FOR
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