All Questions
8,745
questions
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
48
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
131
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
0
votes
2
answers
64
views
How to Determine the Low High Water Mark (LHWM) in Oracle DB? [closed]
How could one determine the position of the Low High Water Mark (LHWM) for a non-partitioned heap table segment in Oracle?
Note: Using Locally Managed Tablespaces (LMT) and Automatic Segment Space ...
- 482
1
vote
0
answers
34
views
DataGrip problem with connection on Linux
I'm working on my college project from Relational Databases subject. I'm using Linux. At college we are using Oracle databases.
I'm facing problem: "the network adapter could not establish the ...
- 11