Questions tagged [oracle]
Oracle is a relational DBMS (Database Management System) created by Oracle Corporation.
75
questions
1
vote
1
answer
141
views
Spring Batch Item Writer Calling Stored Procedure
While migrating a Spring application to Spring Batch, I encountered a scenario where I need to process chunks of records from the database and invoke a stored procedure for each chunk. However, each ...
- 173
0
votes
1
answer
62
views
0
votes
1
answer
53
views
Shortening Oracle SQL containing several unions
I believe the provided code can be rewritten shorter. Now one block is basically copy-pasted. In reality I have 6 such blocks.
This would be the data:
...
- 133
3
votes
3
answers
249
views
Select non-task workorders, but include the costs of the tasks
IBM's Maximo Asset Management platform has a WORKORDER table (265 columns).
Details:
The WORKORDER table contains two different kinds of rows:
WO records (istask = 0)
Task records (istask = 1).
The ...
- 198
1
vote
0
answers
607
views
Find junk values in all tables and columns
Find junk values in all tables and columns:
Loop through all tables in a schema (Oracle 18c)
Loop through each number and text column
If columns have values that are junk, then add a statistic/record ...
- 198
1
vote
1
answer
52
views
capturing counts of open items between dates
DB version is: Oracle 12c. Restricted to the use of inline PL/SQL.
The end goal here is to get a count of open items by day, inclusive of created date, exclusive of the end date.
The data ...
- 113
1
vote
1
answer
35
views
Clubbing three queries that return mutually exclusive records
There is a table in Oracle database with the following data
...
- 151
4
votes
3
answers
3k
views
Updating a huge hashmap from a resultset
I am using Java 7
Problem: I need to retrieve records from a database table based on a condition, orig_setting = 1. This query could return ~1000 records. Parameters from 1-7 of the Params object are ...
- 151
2
votes
3
answers
527
views
Calculate the midpoint of a polyline
I have polylines in a GIS database. The polylines are stored using a user-defined type called ST_GEOMETRY.
ST_GEOMETRY has lots of spatial functions. However, it does not have a polyline midpoint ...
- 198
2
votes
1
answer
112
views
Seek to get acceptable performance of SQL request (SOLVED)
Goal: I want to output all non-standard FK constraints from clients DB, versus our "standard" DB (which contains, by default, 2,631 FK).
Trial: I wrote this code:
...
- 169
2
votes
2
answers
345
views
Build WHERE clause for search conditions [closed]
Here is a set of classes that are used to build where clause for SQL Server and Oracle for different field types e.g. text, <...
- 267
2
votes
1
answer
547
views
Generating and storing a unique salt in Oracle database using Java
This is my account table:
...
- 143
0
votes
2
answers
117
views
Bulkloading xml's into Oracle table
Intro
We have some old(in my eyes) software at the place I work at the moment,
Some stuff needs to be done manually, for instance we need to insert a XML file into a Oracle table, which will trigger......
- 11.6k
2
votes
1
answer
47
views
String manipulation over 2 tables in database to application
I have the following function in the database to do string manipulation:
...
- 121
2
votes
0
answers
4k
views
Using Entity Framework to Call an Oracle Stored Procedure with Multiple Cursors
I wrote the following code to use Entity Framework 6 and Managed Oracle Providers to call an Oracle stored procedure that returns multiple cursors.
Would like some input about the code I used to ...
- 336