I am creating a web application where users have the option to connect to Oracle Cloud. After authenticating to Oracle Cloud, our application will call Oracle C
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production What am I missing here? When I try and create two different but similar (in my mind) pac
I get this missing right parenthesis but I cant find it CREATE TABLE PUBLICACION AS (SELECT id AS id_revista, nombre AS nombre_revista, COUNT(C.dni) AS cuan
I am using Oracle Client 18 Home 1 SQL Developer platform is Windows-10-10.0.18362-SP0 python version is 3.8.8 cx_Oracle version is 8.0.1 cx_Oracle client versi
I have a postgres query that creates an anonymous table from string values and then joins on them like this: select distinct anon_table.string1,
Please explain this 'name' keyword What is it? How we can use it? Syntax?
I have a SpringBoot application in which i use Liquibase to generate oracle schema and tables. When i run the application, it runs fine. But when i try to run t
I have a question related to the "Data Load Rules". Is it possible to load data rules on FDMEE using an external batch script? I have to schedule the job betwee
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