20,299 questions
0
votes
0
answers
38
views
What is equivalant command in Oracle POSTGRESQL copy command [duplicate]
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;
- 533
0
votes
4
answers
140
views
How can I store a list of IDs in a variable to re-use multiple times in a SQL worksheet?
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 ...
- 101
-6
votes
2
answers
112
views
Reverse order of split string parts [closed]
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 | ...
1
vote
1
answer
68
views
Adding a column with default value incorrectly fills a different column
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 ...
- 63
-2
votes
1
answer
135
views
Why is my Oracle tablespace growing so unreasonably fast? [closed]
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 ...
- 1,502
0
votes
1
answer
25
views
Save SMPP session java object in oracle database to reuse across java spring boot pods
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 ...
- 153
2
votes
1
answer
144
views
When a timeout occurs in Oracle, HikariCP commits instead of rolling back
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 -\...
- 41
2
votes
2
answers
44
views
Will after statement level trigger work on dml operations
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,...
- 66
0
votes
0
answers
112
views
Slow message delivery in Java application using Oracle Advanced Queue
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 ...
- 232
1
vote
1
answer
63
views
Combining several rows based on a parameter in Oracle
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/...
0
votes
1
answer
72
views
Oracle Restful Services with PDF files
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, ...
- 1
-1
votes
1
answer
66
views
Which side gets type cast when the WHERE clause and the column type mismatch?
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 ...
- 67
0
votes
4
answers
65
views
Oracle Separator Isolation and Association Inquiry Query Problems
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 ...
- 7
-1
votes
1
answer
71
views
Load XML file to an existent oracle table using oracle sql developer
I´m trying to load an existent XML file into an existent table in oracle.
My XML file as the structure:
enter image description here
<Invoice>
<InvoiceNo>FS TML0001/003123501</...
0
votes
1
answer
76
views
Calculate data based on previous values of rows [duplicate]
I have information in base tables which is like this.
ORDER#
Date
Item
Qty
Onhand
Avl Fill
100030505
2024-11-19
862181010
84.00000
164
80
100030505
2024-11-20
862181010
85.00000
164
-5
100030505
2024-...
- 67