20,335 questions
0
votes
2
answers
42
views
conditional where with subquery
I am using conditional where as shown below to make query more dynamic when there are no condition are meet but I am getting below error while when I omit the (SELECT CP.COLUMN1 FROM TABLE2 CP WHERE ...
- 2,620
0
votes
2
answers
62
views
Function procedure with Oracle standard execution
I am working with multiple projects, one using Oracle 11g and the other with Oracle 19c.
Both of them have multiple databases which I need to share data between them.
Any procedure or function need to ...
- 2,620
1
vote
1
answer
49
views
Rows of table variables and columns of counts, min and max?
I have 3 columns in my table of charges like
CHRG_ACCOM
CHRG_ANCIL
CHRG_TOT
100.00
50.00
150.00
300.00
150.00
450.00
100.00
50.00
150.00
...
...
...
I need row counts, min value and max value for each ...
- 718
2
votes
2
answers
75
views
Oracle query to return each week and month including mid week month changes
I'm trying to return all the individual weeks of the year, with the respective number of the week and number of the week respective to the month.
This query does that but how can I alter the logic to ...
- 57
0
votes
2
answers
75
views
Issue with INSERT ALL SQL statement Oracle
I got an issue with INSERT ALL statement for the below table and this table has a Before Insert trigger which automatically populates the date when the ID_NO column is populated.
CREATE TABLE TestA
(
...
0
votes
1
answer
31
views
How to capture the errored column name in the oracle error table
Inserting the rows from source_table to the target_table using stored proc and the inserting query,
insert into target_table (column_1, column_2)
select (column_1, column_2)
from source_table
log ...
- 2,116
0
votes
1
answer
64
views
SQL*Plus HTML Markup: Preventing Raw HTML Tags from Appearing in Output File
Output needed in this format:
I am using SQL*Plus to generate an HTML report from an Oracle database using SET MARKUP HTML ON. However, the output file contains raw HTML tags as plain text instead of ...
- 21
0
votes
1
answer
49
views
Fetch records from table and perform insert/update on the other table
Processing records from TABLE_1 and inserting into the TABLE_2.
Code structure as follow,
try (PreparedStatement ps = conn.prepareStatement("SELECT COL.. from table_1")) {
ps....
- 2,116
1
vote
1
answer
44
views
Recursive query where parent can be in another table and allowing multiple children
I have 2 tables:
TABLE A:
A_ID
TABLE B:
B_ID; LINKS_TO_A_ID; LINKS_TO_B_ID
They are supposed to represent a chain of actions, where the top of the chain can start both at Table A or Table B (but ...
- 57
2
votes
2
answers
62
views
Split string into columns, dynamically create columns based on length of string
My data looks like this
ID Value
A 123, 456, 789
B 234, 567
I need my output to look like
ID Value1 Value2 Value3
A 123 456 789
B 234 567 NULL
I can do this ...
- 718
0
votes
1
answer
30
views
Oracle Application Express 20.2 on Oracle 11.2.0.4 and APEX_WEB_SERVICE
if I a install Oracle Application Express Release 20.2 on an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit, can I use APEX_WEB_SERVICE API to call some RESTfull servicies and ...
- 596
0
votes
1
answer
43
views
How to find following lines in a bunch of lines?
I have a bunch of lines (type 2002) - some are crossing, some are "somewhere", some where touching another line somewhere, - and some are the continuation of another line.
So I have to find ...
1
vote
1
answer
43
views
relation between main table and sub table
table employee
log_number
last_update_date
user id
1
2024-12-11 10:49:18.087
121
2
2024-12-12 15:49:18.087
131
2
2024-12-17 16:49:18.087
131
select *
FROM employee e1
where e1.last_update_date IN(
...
0
votes
0
answers
32
views
How use the nextVal of sequence in H2 and ORACLE as well
I'm trying to understand how to use the nextVal of a sequence in both H2 and Oracle databases in unit tests of spring boot 2.7
I want to use the H2 only for my unit test.
When i use the syntax of ...
1
vote
1
answer
33
views
Oracle SQL query to set Max of column value to all rows present in the query based on group by clause
I have a select query which returns below rows :
Item_no
item_type
region
valid
values
10001
ATC
US
Yes
CY412
10001
ATC
US
No
DSS1
10001
ATC
RU
No
RX111
10001
ATC
RU
No
DS12
Need to use same select ...
- 19