Had a task to compress some large tables to reduce storage costs by using Oracle's Advanced Compression. Here is the statement : execute immediate 'ALTER TABLE
Is it possible to add clear button in date picker? I have this item that is read only to avoid wrong format when inputting. So, I'm thinking of a solution to ad
I am creating a stored procedure in Oracle database that's resulting in error "ORA-01858: a non-numeric character was found where a numeric was expected". My pr
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