Skip to main content
152,630 questions
Newest Active Bountied 1 Unanswered
0 votes
1 answer
38 views

Environment Oracle server v19c Using jdbc driver and ucp from com.oracle.database.jdbc:ojdbc10-production:19.29.0.0 Tomcat10/Java17/SpringBoot3.5 application UCP logging enabled with oracle.ucp.level ...
Jan Bentzen's user avatar
  • 21
-4 votes
1 answer
83 views

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. ...
mlwacosmos's user avatar
  • 4,561
2 votes
2 answers
97 views

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, ...
Pantea's user avatar
  • 143
1 vote
2 answers
101 views

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 ...
AdhiHari's user avatar
  • 27
0 votes
0 answers
56 views

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 ...
riskop's user avatar
  • 1,839
Advice
1 vote
4 replies
66 views

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 ...
jakk's user avatar
  • 1,253
-2 votes
2 answers
90 views

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....
Sean Whiting's user avatar
  • 51
Advice
0 votes
3 replies
43 views

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 ...
Nibin George's user avatar
  • 67
0 votes
1 answer
84 views

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....
AC''s user avatar
  • 1
Advice
0 votes
0 replies
53 views

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))...
titi zarif's user avatar
  • 31
Advice
0 votes
0 replies
34 views

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 : ...
Binod Kumar's user avatar
  • 3
3 votes
1 answer
91 views
+100

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....
SGiux's user avatar
  • 883
0 votes
1 answer
110 views

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 ...
Iori Kyo's user avatar
  • 95
1 vote
2 answers
64 views

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 ...
Pierrick Dupas's user avatar
  • 11
Best practices
0 votes
7 replies
161 views

I am trying to find the right pattern which can extract the date from any string """ 28/11/22 11-23333 to 28/11/22 11-23333 28/11/22 to 28/11/22 something 20.02.2022 end to 20....
Hari's user avatar
  • 11

15 30 50 per page
1
2 3 4 5
…
10176