20,294 questions
1
vote
2
answers
60
views
XML in Oracle PL/SQL - How to read a big hexBinary node?
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 ...
0
votes
0
answers
40
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
-6
votes
2
answers
118
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 | ...
-2
votes
1
answer
170
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
2
votes
1
answer
171
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
0
votes
0
answers
115
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
0
votes
1
answer
79
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
0
votes
4
answers
67
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
0
votes
1
answer
78
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
0
votes
2
answers
69
views
Function procedure with Oracle standard execution
I am working with multiple projects, one using Oracle 11g and the other with Oracle 19c.
Both of them have multiple databases which I need to share data between them.
Any procedure or function need to ...
- 2,622
2
votes
2
answers
88
views
Oracle query to return each week and month including mid week month changes
I'm trying to return all the individual weeks of the year, with the respective number of the week and number of the week respective to the month.
This query does that but how can I alter the logic to ...
- 57
0
votes
1
answer
77
views
How to capture the errored column name in the oracle error table
Inserting the rows from source_table to the target_table using stored proc and the inserting query,
insert into target_table (column_1, column_2)
select (column_1, column_2)
from source_table
log ...
- 2,116
0
votes
1
answer
54
views
Fetch records from table and perform insert/update on the other table
Processing records from TABLE_1 and inserting into the TABLE_2.
Code structure as follow,
try (PreparedStatement ps = conn.prepareStatement("SELECT COL.. from table_1")) {
ps....
- 2,116
2
votes
2
answers
70
views
Split string into columns, dynamically create columns based on length of string
My data looks like this
ID Value
A 123, 456, 789
B 234, 567
I need my output to look like
ID Value1 Value2 Value3
A 123 456 789
B 234 567 NULL
I can do this ...
- 716
0
votes
1
answer
56
views
How to find following lines in a bunch of lines?
I have a bunch of lines (type 2002) - some are crossing, some are "somewhere", some where touching another line somewhere, - and some are the continuation of another line.
So I have to find ...
1
vote
1
answer
33
views
Oracle SQL query to set Max of column value to all rows present in the query based on group by clause
I have a select query which returns below rows :
Item_no
item_type
region
valid
values
10001
ATC
US
Yes
CY412
10001
ATC
US
No
DSS1
10001
ATC
RU
No
RX111
10001
ATC
RU
No
DS12
Need to use same select ...
- 19
0
votes
4
answers
74
views
Get largest cumulative sum for row subtypes without using a self join
I'm working on a problem and am stuck at making it work without a join.
I've got a table, where each product_type has a number of regions. I need to find the region with the maximum quantity sold for ...
0
votes
1
answer
77
views
Oracle SQL 11gR2 linux spool to xls -> German Umlaute not working
I’m working on an Oracle 11g database (Oracle Database 11.2.0.4.0) with linux sqlplus and I need to export query results to a file that can be opened in Excel. The data includes German umlauts (Ä, Ö, ...
- 1,008
1
vote
0
answers
68
views
DRF issue while attempting to inspectdb command error appears: # The error was: ORA-00904: "USER_TABLES"."DEFAULT_COLLATION": invalid identifier
I have an Oracle database version 11.5.10.2.
Recently, I study DjangoRestFramework in order to perform own APIs.
Firstly, command python manage.py runserver doesn't work due to unable to connect to ...
0
votes
0
answers
43
views
How to perform calculation based on multiple tables? [duplicate]
I have 2 tables in an Oracle database. The first one is KEY_SCRIPT which stores something called 'keys' along with their value:
ID
KEY_NUMBER
KEY_VALUE
A
1
11
A
2
6
A
3
5
The second table is WARNING ...
- 9
0
votes
2
answers
65
views
ExecuteQuery method is missing when using Oracle Provider 7.12 + EF Core 7 on LinqPad
I need to retrieve a sequence value to use when adding new records on table PERSON. The pure SQL to do this is:
SELECT SEQ_PERSON_ID.NEXTVAL FROM DUAL
I tried to use this code:
var newID = this....
- 6,431
0
votes
1
answer
54
views
There is no raw query execution function
I have a project with .NET Core 3.1 that worked with Oracle DB which uses these libraries:
Microsoft.EntityFrameworkCore v5.0.12
Microsoft.EntityFrameworkCore.Design v5.0.12
...
- 5,299
0
votes
1
answer
56
views
Oracle Table transpose
Below is my table
CREATE TABLE "TABLE1"
( "REG" VARCHAR2(20 BYTE),
"SB" VARCHAR2(20 BYTE),
"VKYC" VARCHAR2(20 BYTE)
) ;
Insert into TABLE1 (...
- 533
0
votes
2
answers
74
views
Get the list of records to delete based on a column and list of tables
I have a table Employees:
EmployeeId
EmployeeMatricule
1
XCV
2
HKO
I have a list of EmployeeMatricule that I need to use to delete records from the table Employees and the tables which are in ...
user9517769
0
votes
0
answers
117
views
Why the oracle database changes the non latin character encoding?
I am using Oracle database with AR8MSWIN1256, and unfortunately I cannot change the encoding to UTF8.
Then I have defined a table with a column type of varchar2
and tried to run sql operations from a ...
- 334