7,661 questions
-3
votes
0
answers
80
views
Displaying lines corresponding to more than row in result [closed]
I have this request that should do a data recovery on all table rows:
UPDATE TABLE_2
SET SUBMITTER_ID =
(SELECT
TABLE_1.AGENT_ID FROM TABLE_1
WHERE TABLE_1.CREATION_DATE =
(...
- 3,276
0
votes
2
answers
77
views
How to backfill missing values from another record in Oracle SQL
Here is my query:
select product_id, long_description
from p
where product_id in ('AA103','AA105','AA1101','AA1107','AA1112');
table 'p' does not have any records for AA105 & AA1112. In my final ...
- 9
Advice
0
votes
0
replies
21
views
How to find correct tables, columns, and modules for Oracle Fusion BIP reports?
I’m new to Oracle Fusion Applications and BI Publisher (BIP). Whenever I receive a reporting requirement (for example, a Timecard report), I struggle to identify:
Which module it belongs to
Which ...
Advice
0
votes
0
replies
48
views
how should I check effect of using ‘return as locator’ if its possible to track changes through column size after data insert?
Refer to object-relational-developers-guide/Nested Table Locators
‘For large child sets, the parent row and a locator to the child set
can be returned so that the child rows can be accessed on demand; ...
- 31
1
vote
1
answer
133
views
Oracle SQL Query with User Input variable
To all valuable gurus out there.
Quick note to begin. Company that hosts the Oracle database has no expert manager for the server, so no general support is available. The DB is going downhill fast as ...
- 13
0
votes
2
answers
114
views
How to SELECT inside a DECLARE block? [duplicate]
Context:
As a developer in a large company, I am allowed to query (read-only) any table in the database and see the result (for debugging and investigation purposes).
When I do so (either from ...
- 1,804
0
votes
1
answer
95
views
Equivalent to replace input date from User/API In PostgreSQL from Oracle
I am in the process of transitioning Oracle queries to PostgreSQL and I am trying to pass a date range to pull back the results.
The original Oracle query is below:
select
iss_id
,date_created
...
1
vote
1
answer
66
views
error when access oracle server (with docker) from host sqlplus
[Q] How to fix ORA-29024: Certificate validation failure when connecting from host to Oracle in Docker?
my docker image: container-registry.oracle.com/database/adb-free:latest-23ai
ubuntu 24.04.1, ...
- 67
0
votes
0
answers
68
views
Oracle SQL Developer Open/Save Files Issue (Version 24.3)
Latest version of Oracle SQL Developer (24.3) has a problem opening and saving Worksheet files that contain the hash (#) character.
The ‘open file’ dialog strips off any part of the filename after a ...
- 35
0
votes
1
answer
136
views
Oracle SQL DBLink with many tables and joins
I'm trying to execute an Oracle SQL query that can hit two different database servers at once. Both servers have the same table definitions however the SQL query is hitting many tables.
Simplified ...
- 178
1
vote
1
answer
99
views
Oracle SQL Developer claims missing select just because of end line comment
If I select all text in the SQL Developer and execute it, it works:
select 16 cc, date '2025-03-05' coDate, 18 nr, 594.34 tvaInc, 1 cat from dual union all
select 16 cc, date '2025-03-06' coDate, 22 ...
0
votes
0
answers
668
views
How to fix ORA-29024: Certificate validation failure when using UTL_SMTP with STARTTLS and Wallet in Oracle 19c?
I'm migrating an old Oracle send_mail procedure to use authenticated SMTP with STARTTLS over port 587, in Oracle Database 19c (version 19.0.0).
✅ My Goal:
Send emails using UTL_SMTP through an SMTP ...
- 451
1
vote
1
answer
79
views
Adding a column with default value incorrectly fills a different column
After executing the following script:
alter table test_table
add (test1 varchar2(1 char),
test2 varchar2(1 char) default 'T' not null);
I got interesting results... both columns are filled with ...
- 63
-1
votes
2
answers
87
views
Get highest value from different rows
In the screenshot attached, it shows that one ID has different parts.
SET shows the combined parts (A+B+C). The WEIGHT is the total of the parts, but not the LENGTH.
The SET LENGTH is 0, and I need to ...
user2835157
1
vote
0
answers
176
views
Oracle SQLcl "project stage" incorrectly ordered changelog
I'm testing the recently released "project" feature in Oracle SQLcl (version: 25.1.1.0 build: 25.1.1.120.1002).
After watching some Oracle videos I decided to use the feature on a real ...
- 13