Questions tagged [oracle]
Oracle is a relational DBMS (Database Management System) created by Oracle Corporation.
76 questions
3
votes
2
answers
194
views
Clean up verbose code for Oracle SQL
I have the following Oracle SQL code that works, but I would like to try and find a way to clean it up so it's not so repetitive. It is looking at orders for a part ordered each FY in an Oracle ...
- 33
1
vote
1
answer
182
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
125
views
0
votes
1
answer
80
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:
...
- 143
3
votes
3
answers
309
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 ...
- 218
1
vote
0
answers
663
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 ...
- 218
1
vote
1
answer
80
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
2
votes
1
answer
54
views
Clubbing three queries that return mutually exclusive records
There is a table in Oracle database with the following data
...
- 161
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 ...
- 161
2
votes
3
answers
650
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 ...
- 218
2
votes
1
answer
149
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
429
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, <...
- 257
2
votes
1
answer
580
views
Generating and storing a unique salt in Oracle database using Java
This is my account table:
...
- 143
1
vote
2
answers
148
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.8k
2
votes
1
answer
62
views
String manipulation over 2 tables in database to application
I have the following function in the database to do string manipulation:
...
- 121