I am trying use the data from a column in one table as column aliases of another table. DECLARE var1 VARCHAR(20), var2 VARCHAR(20); BEGIN WITH TABLE1
I have multi-part polyline vertices stored as individual rows in an Oracle 18c table. ASSET_ID PART_NUM VERTEX_NUM X Y M --------
I have a PL/SQL sproc which sends an email, with addressee and such as parameters. We recently migrated it, to a new environment, and switched it from using an
I need to delete all the audit and trace logs, one day before, from AWWS RDS oracle 12c. But in the logs sections of RDS, still showing same count. I tried thes
Curent situation Currently I have this PL-SQL script with almost fifty words "hard-coded": DECLARE categoryToSearch VARCHAR2(16); BEGIN catego
When registering, I got the London region, but I am in Ukraine and I want to select the Frankfurt region. There is a subscription to it, how can I do this?
I have a requirement where I have to save a lot of data into an Oracle DB. I want to use multithreading to speed things up. Everything is in a transaction. I ha
The start_on column in RIDE table is starting date and time for each ride and ends_on column is ending date and time of ride. i have to fetch the ride whose tr
There's a way to store a set of codes into a variable in Oracle SQL? I have these codes and I'll need to use them in different parts of my que
Getting the above error in the IN statement. Can you anyone help? ORA-00936: missing expression 00936. 00000 - "missing expression" *Cause: *Action: Error
I have an huge Oracle table to process, so I define a list of where clauses to read by each Spark node. In the middle of the processing I need to join the data
I have a table with one CLOB field (s.File) and I need to create a join on this table to get related data. However, in Oracle, CLOBs are not allowed in group by
I'm running macOS Catalina 10.15.7 and I need to install Oracle Instant Client to run run a Perl script that connects to a DB. 1. Installing Oracle Instant Clie
I am trying to see if there is a way to improve the way data is inserted and updated. I am using ORACLE DB with JDBC. The current way i'm doing is to update (e.
I'm building system, in which I decided to use GUIDs as primary keys in many tables. I took this decision in order to be able to develop tool for integration te
I've searched but found no answer, so i resort to you. I have an Oracle table, say "Countries" that exists for ages in database 2 (target). Now, we want to sync
I have the following code, which seems to be working. Is there a way I can add a date, timestamp to the type definition? If so, how would reference the columns
I'm trying to copy a specific cell from an Interactive Grid (which is in Display Only mode, if that matters), and instead of copying the cell I'm in, I'm copyin
If is it possible change delay of JMS Message when it's already in the queue? When I send message via JMS, I set jmsMessage.setIntProperty("JMS_OracleDelay", 12
Thanks a lot for the opportunity.. I will try to pass 2 parameters in my Quarkus rest code, using Hibernate call stored Procedure at oracle database. Unfortunat