I have an XML file with a node containing a file that has been converted into hexbinary. The ultimate goal is to read that node, convert it back to an actual file and store the path of that file in a ...

Let's say I've created a stored procedure MY_ABC_PROC() and I schedule it to be ran thrice per day: begin dbms_scheduler.create_job( job_name => 'MY_ABC_JOB', job_type => ...

POSTGRESQL having command like copy to export CSV file , like any command is available in Oracle. Example for POSTGRESQL Copy (select * from emp) to 'D:/test.csv' with delimiter ',' csv header;

I regularly have to do support at work using various database tables, checking and comparing values between different tables but always from a starting point of a set of ID values, as strings. I've ...

My simple Oracle SQL select statement: select id, my_column from my_table; returns the following output with over 1.000.000 rows in the result set: | id | my_column | | 1 | abc.mno.xyz | | 2 | ...

After executing the following script: alter table test_table add (test1 varchar2(1 char), test2 varchar2(1 char) default 'T' not null); I got interesting results... both columns are filled with ...

I have problem in understanding why my table entries occupy so much space. My DB is growing unexpectedly fast. In detail: There is the following table DATA_SENSOR: create tablespace DATA_SENSOR ...

How save the SMSC session object in oracle database to reuse the same session object across java spring boot pods Note: We have 22 spring boot pods but SMPP server side agrees only to open 5 session ...

When a timeout occurs in the database, HikariCP does not rollback, but commits and terminates abnormally. @Transactional(rollbackFor = Exception.class) method{ 1.delete table11 2.delete tablel2 -\...

I have created this statement level trigger but it executes like row level trigger... CREATE OR REPLACE TRIGGER trg_citizens_log AFTER INSERT ON citizens BEGIN INSERT INTO trigger_log ( log_id,...

I have a Java application that connects to Oracle Advanced Queue (AQ) and listens for various event types. The Java server and the Oracle server are on different machines but within the same data ...

I have a table like below: C_ID O_ID T_START T_STOP 1 1 5/7/25 12:06 5/8/25 11:09 1 2 5/8/25 11:24 5/10/25 11:24 1 3 5/10/25 15:41 5/11/25 12:38 1 4 5/14/25 11:24 5/16/25 07:20 1 5 5/16/25 08:50 5/18/...

I have a database table that stores PDF files and other files types and I want to serve them to a calling application using Oracle Restful Services. The table has the following fields: id, ...

Let's say we have, some table of data with N number of rows and a VARCHAR column that I want to apply a WHERE clause to So we have the user enterable argument in the WHERE clause like: SELECT * FROM ...

Oracle has a column that contains delimiter-composed data. The data in that column is as follows. 100-G-100A/B 200-K-200A/B/C 300-EF-300A/B/C/D/E/F I would like to make sure that it is separated ...