I am using Oracle database. The below query is not working as expected. select * from cst_cust_attributes where attribute_value='event' and attribute_value='
I am trying to connect oracle database from AWS glue using cx_oracle but i am getting this error message DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle
I am writing a unit test case using MOQ framework for testing an Oracle stored procedure returning a RefCursor. My project is in c# and we are using Dapper to c
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