Questions tagged [oracle]
Oracle is a relational DBMS (Database Management System) created by Oracle Corporation.
70
questions
-2
votes
0answers
17 views
4 tables join Oracle [on hold]
I have 4 tables and Im trying to join them. it doesnt work yet.
Hello community.
I have 4 tables and Im trying to join them. it doesnt work yet. I need to join that user can retrieve the Engineer’s ...
2
votes
2answers
170 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, <...
2
votes
1answer
62 views
0
votes
2answers
25 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....
2
votes
1answer
40 views
String manipulation over 2 tables in database to application
I have the following function in the database to do string manipulation:
...
2
votes
0answers
1k 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 ...
0
votes
2answers
90 views
SQL Statement with a Select Statement Inside a Where Clause
Is there a more efficient way to write the following PLSQL statement? It seems inefficient to me to have the SQL statement nested inside the where clause.
...
1
vote
1answer
63 views
Oracle SQL Code - Multiple Joins used
I'm currently working on some SQL code within Oracle Fusion BIP but it's not very optimised as it's using multiple LEFT,RIGHT and FULL OUTER joins to link tables together.
Unfortunately this is ...
1
vote
2answers
44 views
Query for customer quotes by date range
I have a table (Oracle):
customer_quote
------
int id
int part_key (fk)
int condition_code (fk)
number unit_price
int qty_quoted
date entry_date
With a query ...
1
vote
2answers
4k views
Calling an Oracle Stored Procedure with C# Code
I came across this code in a project I inherited. I am curious if all the nested using statements make sense to anyone else. Also, wondering if this code could not be written in a better/leaner way?
<...
2
votes
1answer
78 views
Database model for a hotel
I have to create a Hotel database according to these requirements:
information about guests should be found, information about rooms divided into categories, reservations (ordered by a type of a room ...
4
votes
0answers
99 views
Program to pull data from an Oracle database
EDIT: I should clarify that this program currently works as intended (not looking for help making it work); I just want to understand what I could have done better in terms of design.
I work on a ...
1
vote
0answers
52 views
Determining how many tabs to create and how many lines per each tab
I wrote this PL/SQL code for Oracle Apex, works perfectly. At the beginning I had more than 200 lines for the same code. I’m new and I’m still learning. After searching on multiple websites I found ...
0
votes
1answer
79 views
Refactoring the legacy code which is using '§' char in the code
I have a legacy code (might be 20 years old) as shown below. Where they are using the non ASCII '§' char in the code.
First they are preparing a ...
1
vote
4answers
67 views
Select multiple count queries in single query
I currently have 6 very similar queries that I'm trying to increase performance on by making them all subqueries in 1 query. I'm not sure what is better performance wise, keeping them 6 separate ...
1
vote
1answer
74 views
File names to database table
I have files in subfolders on a network drive. I want to create a list of files, and insert that list into an Oracle table.
I can successfully iterate through the files in the subfolders and do the ...
0
votes
1answer
745 views
Exception handling and releasing of OracleDB connection
Before I start implementing several REST API service endpoints, I'd like to make sure that I'm not doing it totally wrong.
...
3
votes
1answer
411 views
Update pass-through query from a form (an alternative to stored procedures)
I've adapted a script from the book Microsoft Access Developer's Guide to SQL Server that I use to update a pass-through query via a form.
One way to pass parameters to a pass-through query is to ...
2
votes
0answers
217 views
Calling PL/SQL functions using JDBC in a Spring clone
I started to modify some old code and ended up creating a sort of spring jdbc framework.
I know just the most popular design pattern, so I was wondering if my design was good.
For example, to call ...
1
vote
0answers
64 views
Given table of values, find rows that match a predicate
I'm working on the following problem:
We have a Row Java type that roughly represents that of database table row (meaning it has a set of fields and is identified ...
0
votes
0answers
70 views
Using a boolean column as an index to process rows vs partitions or other mechanisms
I receive files from many sources (SFTP, REST, SOAP, etc.) in many formats (CSV, JSON, XML, etc.) and then process them at a later time in a ...
3
votes
2answers
85 views
Employee Compensations Query
I have a pretty straightforward query that I am essentially hard-coding. I have a table with 3 keys and a description field.
The first key has to do with the type of compensation for an employee (<...
6
votes
4answers
661 views
Simple Oracle connection using JDBC
I'm trying to continue the learning process in Java, and I've made a simple yet useful class which will allow me to retrieve the data inside a table from an Oracle DB, using JDBC.
What I'm especially ...
5
votes
2answers
72 views
Script for updating an Oracle database
I have the following piece of Perl script for updating an Oracle database. It's working perfectly fine, but I want to know how I can simplify this script.
...
4
votes
1answer
97 views
Identify the installed Oracle driver, Scan the .NET GAC for Incompatible Assemblies
My day job is supporting a piece of software that just started using the DevArt Oracle drivers, which utilize the Oracle.DataAccess .NET drivers.
However, the ...
1
vote
1answer
34 views
Check user changed his password recently or not in specific period
I am working on Oracle SQL. What I am trying to do is:
Query a record with ID
If the record does not exists use user input value
If the record exists, compare ...
1
vote
1answer
99 views
Create multi-dim array from cursor
I'm executing a cursor. I have cut off the code how the procedure is called and executed. This part is efficient. At last I have a small cursor. I'm calling the procedure, which returns this cursor ...
1
vote
1answer
3k views
Oracle trigger to keep a copy of deleted records in another table
I am using this trigger to keep a copy of the deleted record from table Orders_Details in table Orders_Details_Deleted.
I am ...
3
votes
1answer
3k views
8
votes
1answer
189 views
Extract data from a DBMS, create a CSV dump and transfer it to an FTP server
First of all, my code does work as expected at least to some extent. The intention of the program is to extract data from a DBMS in order to create a CSV dump and transfer it to an FTP server.
My two ...
1
vote
1answer
116 views
Convert MS SQL datetime to Oracle varchar(32) interval
I have a query against an MS SQL database that takes the resulting dataset and stores it in an Oracle database table which then gets joined to another Oracle table using the column ...
4
votes
1answer
131 views
Oracle Database Communication/Operation
I am creating an application that will move specific data from one Oracle database and moving it to a MySQL database. I created this class to help keep myself organized and this class holds all of the ...
4
votes
1answer
106 views
Highest andLowest in PLSQL
I have made a procedure to display the highest and the lowest popular Items for a particular time of a given date. The procedure works with no errors or exceptions ...
2
votes
1answer
57 views
Generating business summary stats in SQL dynamically, based on an inputted date
I have the following Oracle SQL query to generate some system-stats. I am interested in making it a more efficient and readable query.
...
0
votes
2answers
93 views
1
vote
1answer
640 views
Oracle query to split 1 row into two where conditions are applicable
The scenario question:
"I'm having difficulties with splitting a single row into two individual ones."
My test schema is:
...
8
votes
2answers
215 views
Checking for Duplicates, Except
I have a query that returns records that have duplicate names within a given DBSTATUS. I used to do this with a direct connection to the remote oracle database ...
3
votes
1answer
98 views
Refactor (DRY, KISS) QueryStatus event for VS Addin
I have complex logic in QueryStatus event (CommandTarget) for a VS Addin (VS 2010).
I'm a newbie using C#.
I would like elegant, easily maintainable code that follows DRY and KISS principles. Maybe ...
3
votes
3answers
435 views
Counting business days in a month, ignoring holidays
This table simply contains date information. I went ahead and used what I currently have since this is a one-time operation. However, since I only recently started working with Oracle, I would like to ...
6
votes
2answers
121 views
Out of one Oracle into another
A project that I have been working on required data to be transferred from an Oracle database into MySQL. The process I devised for that transfer involved a query (included below) on the Oracle ...
8
votes
2answers
9k views
Filter out date records which don't fall within or span a date range
I have records which have specific time spans. The need is to select records which adhere to the following three rules (read them as or conditions) concerning a ...
6
votes
1answer
60 views
Trying to avoid a double full scan with aggregates in query
I have a statistics query I'm trying to run against the below table:
...
2
votes
1answer
598 views
Refactor Oracle Entity Framework lambda query
I had a ugly problem and wrote an ugly query.
Query creates a cache that is used to get person id when I have {full_name, id_code?, birth_date?}. By question mark I mean that it is perfectly valid ...
1
vote
1answer
307 views
Slow delete query on table with composite index
after profiling my application, it turns out that a single method is taking 3 minutes to run, which is about a third of the total runtime.
The method deletes approx. 400.000 rows from each table (<...
5
votes
1answer
151 views
Tuning a query for performance
I am running this query and it takes several minutes to complete. How can I tune it (unfortunately I don't have the privileges to run an SQL tuning advisor)?
...
5
votes
1answer
5k views
Length limited listagg for muliple m:n relations in a view
I have a few views that all follow the same pattern. They select a primary key from some main table and then a few semicolon seperated strings of captions of related rows over many-to-many relations. ...
3
votes
2answers
1k views
1
vote
1answer
1k views
SQL double nested query
This query produces the results I want.
Is there a less wordy or more effective way to write this query?
...
3
votes
2answers
140 views
Searching through tables for a value
I have a PL/SQL stored procedure which searches for a row in 3 different tables (not all columns are the same).
The logic goes as follows:
...
10
votes
2answers
701 views
Comparing client lists with Cross Joins
I've written a query to compare the clients in our database with the people in a list that I've received. It needs to check if anyone from the list is one of our clients. I've created a temporary ...
