152,636 questions
-4
votes
1
answer
70
views
Aggregate rows from another table to the select of one table [closed]
Let's say I have a table named People with a column PeopleID. I have another table Payment. Each row in this table has 3 columns:
PeopleId, Amount, Date
The date is always the fist day of the month. ...
- 4,561
2
votes
2
answers
73
views
MongoDB to Oracle insert runs in reverse date order
I have Python code in which I am reading data from MongoDB and insert it into a table in Oracle database. I have removed some parts of the code (importing libraries, connecting to MongoDB and Oracle, ...
- 143
0
votes
2
answers
95
views
Convert the string date type into date type while creating a table
I am trying to convert the string date type that retrieved from a column.
Below is the scenario
#input
date_str
02/08/24
21/09/2023
25.02.16
null
null
I need to convert above column into a new ...
- 7
0
votes
0
answers
54
views
"DefaultJpaDialect does not support custom isolation levels" when upgrading to spring batch 5
I am upgrading an app to newest Spring Boot 3, and because of that Spring Batch is upgraded to 5.2.3 (from 4.3.10).
The application did not persist batch states previously, it was using the "map ...
- 1,839
-3
votes
0
answers
54
views
How to extract date based on two columns in oracle? [closed]
I need to extract the date based on two columns and retrieve like below
full_match tr_date expected_date
03/12 10-jan-23 03-dec- 22
12/12 11-jan-23 12-dec-22
23/10 11-nov-...
-2
votes
0
answers
84
views
Oracle: how to filter for the partial date from any string appear in the column? [closed]
I have a case where I need to filter for the partial date string from a column.
Here is the input:
date_value
-----------------------------
7-03 start 4444
03/2022 follow up
1111 7-03 03/2022 ...
- 15
Advice
1
vote
4
replies
65
views
Check valid identifier name in Oracle
The database tool in IntelliJ can detect if an identifier needs to be quoted to make a statement work.
If I use a valid table name, the quotes are removed.
How can I do the same?
The best would be a ...
- 1,253
-2
votes
2
answers
90
views
Oracle SQL Test to identify missing rows for unique identifier
I am trying to find an Oracle SQL to test whether a table (CONTACTS) contains two rows of data for each primary key (PK) called REF_NO.
The table has a PK called REF_NO and a second PK called CONT_IND....
- 51
Advice
0
votes
3
replies
43
views
Permission to view the body of a procedure/view/function from a read-only user on Oracle Database
I was wondering if there is any privilege or work around that allows a read-only user I created on Oracle to see the DDL of procedure/view/function from third party apps like SQL Developer.
Currently ...
- 67
0
votes
1
answer
82
views
Error when calling dbms_cloud.export_data
I'm trying to do my first CSV export into an existing AWS S3 bucket. Calling with type CSV:
call dbms_cloud.export_data(credential_name => 'cred', file_uri_list => 'https://s3.us-east-2....
- 1
Advice
0
votes
0
replies
53
views
How data length is calculated for a column with ref data type to a table object?
Refer to following example, my question is how data length is calculated for ITEM100_ ?
create or replace type object_test_0 as object
(item1_ varchar2(100),
item2_ varchar2(10),
item3_ varchar2(10))...
- 31
Advice
0
votes
0
replies
33
views
Data Pipeline for Bringing Data from Oracle Fusion to Azure Databricks
I am trying to bring Oracle Fusion (SCM, HCM, Finance) Data and push to ADLS Gen2. Databricks used for Data Transformation and Powerbi used for Reports Visualization.
I have 3 Option.
Option 1 :
...
0
votes
0
answers
49
views
+100
Testcontainers Oracle XE works locally but fails with ORA-12514 on GitLab CI using Podman service
I'm running integration tests using Testcontainers with Oracle XE.
Locally, everything works fine.
On GitLab CI, using a Kubernetes executor with Podman as a Docker service, the tests fail with:
java....
- 863
0
votes
1
answer
109
views
Connecting to Oracle database is fast with C# ADO.NET, but slow with Java JDBC
Here is the Java test code I wrote. It takes about 40 seconds to connect to the Oracle database using JDBC, but similar code in C# using the OracleConnection.Open method completes in less than 1 ...
- 95
1
vote
2
answers
64
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 ...
