All Questions
8,748
questions
-1
votes
0
answers
8
views
How to use incremental data in stored procedure fetching in a table basis on serno. For eg: latest max serno is 100 at t=0, 103 at t=1, so on
I have to include this incremental data in stored procedure to generate file from t=0 and t= time take by procedure to complete.
select max(serno) from incremental_src ;
o/P: 100 at t=0
o/P: 105 at t=...
0
votes
1
answer
10
views
Update Onprem oracle table from aws glue python shell using oracledb
I have a usecase that needs to update an onprem table using the aws glue python shell.
Please note i want to use python-oracledb in thick mode
I have installed the oracledb
I dba has set up a jdbc ...
- 165
0
votes
2
answers
51
views
SQL Query - Ignore row if data is null for multiple rows on single condition
I have a below table
cid
step
cr_time
120
S02
08-JUL-24 09.35.19.000 AM
120
S03
08-JUL-24 01.35.19.000 PM
120
S04
09-JUL-24 02.35.19.000 PM
121
S02
09-JUL-24 07.35.19.000 AM
121
S03
09-JUL-24 02....
- 606
-2
votes
0
answers
16
views
SQL Plus login issue
ERROR
ORA-12543: TNS: destination host unreachable
I have been facing this issue for the past few weeks can anyone resolve this?
Help from the community to resolve the problem of getting the error ...
0
votes
1
answer
33
views
Oracle DB function to display with date manipulations
I have created a PL SQL function to calculate amount based of rates stored in the database for different period, The function is supposed to iterate through given month and get the rate of each month ...
0
votes
1
answer
39
views
Update TransactionId based on mapping table data
I have 2 tables:
Table 1: ProductTransaction (PK is both the column)
Here, TransactionId value options will be 1 or 2 or 3 | 1 and 2 | 1, 2 and 3.
Only 3 combinations are possible. ProductId 5 has ...
- 59
1
vote
1
answer
68
views
INSERT and UPDATE the Values into the table based on condition
I have 2 tables:
Table 1: EnrollmentTransaction (PK is both the column)
EnrollmentId | TransactionId
-------------+--------------
5 | 1
5 | 2
6 | 3
7 | 2
7 ...
- 59
0
votes
0
answers
12
views
Oracle autonomous db update api not working
TypeError: Cannot read properties of undefined (reading 'longTermBackupSchedule')
at getJsonObj (/home/ubuntu/work/OCI-CloudKIT/node_modules/oci-database/lib/model/update-autonomous-database-details....
- 1
1
vote
0
answers
31
views
Go-Ora Refcursor connection
Working with go-ora refcursor, sometimes I'm getting can't query RefCursor: driver: bad connection
I use shared connectin like:
func main() {
// Establish a connection to the Oracle database
...
- 1,838
0
votes
2
answers
87
views
INSERT OR UPDATE based on table data in single query
I have 2 tables:
Table 1: EnrollmentTransaction
EnrollmentId | TransactionId
-------------+--------------
5 | 1
5 | 2
6 | 3
7 | 2
8 | 3
8 ...
- 59
0
votes
1
answer
33
views
Oracle group in rows
I have a table that I would like to group by row. With "group by" the entire column is always grouped.
Source-Table
ID
HBS1
1
MU
1
S
1
S
1
S
1
T
1
T
1
SZ
1
S
1
S
1
S
Wish-Table
...
2
votes
1
answer
49
views
Oracle Scheduler Job Failing
I submitted a scheduler job in Oracle to run at a specific time daily. However, when I checked today, the job had failed as indicated in USER_SCHEDULER_JOBS. Where can I find the reason for its ...
- 65
0
votes
1
answer
133
views
Oracle APEX - ORDS_PUBLIC_USER is a common user [...] require CDB$ROOT connection
Let's say first that i'm a noob with server and i jumped to linux world only an year ago...
I'm trying to set up my Oracle APEX installation on Oracle Linux 9 (in a VM) for develop a custom software ...
- 5
1
vote
1
answer
29
views
Connection to Oracle database in QGIS analogous to ArcGIS
I'm trying to connect to an Oracle database in QGIS. It works perfectly with ArcGIS Pro, where I insert the platform, instance, authentication type, username and password. However, in QGIS, there are ...
- 11
1
vote
1
answer
80
views
How drop unused column with dbms_redefinition in Oracle database?
I don't really understand how to delete columns using the dbms_redefinition utility. All the time there are some strange errors and data overwriting. Disabled foreign keys appear in other tables and ...
- 178