Category "oracle"

Oracle Pivot with 3 Tables

I am using a PIVOT to combine two rows with the same ID into a single row: SELECT B1_ALT_ID, B1_CHECKLIST_1, B1_CHECKLIST_2 FROM B1PERMIT A JOIN BCHCKBOX B ON A

Function that given a parameter will calculate a value from different tables using different logic

I am needing to create a view, and one of the columns in the view needs to calculate a value for the metric. The source table for a metric will be different dep

How to use Oracle bitwise operators &, |, ^, ~?

I need to use Oracle bitwise operation in my project. I know there is the BITAND() available for the purpose. As far as I know BITAND() is the only such opera

Trigger that changes value in another table /plsql

I've created two tables: Employees and Departments CREATE TABLE EMP ( emp_id number(3) PRIMARY KEY, dept_id Number(3) NOT NULL, emp_name Varchar2(50) NOT NU

oracle insert on subselect gives ORA-00936

I am trying to insert into a table, whose values are same except few from the same table with max sequnce number based on an ID. insert into ENT_ROLE_USERS_HIST

Cannot drop table from schema

I am trying to use a simple "Drop Table" Statement in PL/SQL Developer on some tables, but they won't drop. The tables are quite large, but I've never had this

Classify if a customer converted on initial email or reminder email using SQL

I have been stuck to get around this in Oracle SQL. I have a table that looks like following. cust_id event event_date camp_id email_ind(calculated column) 1 O

How to authorize Rest API in Oracle Cloud?

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

Pipelined function gives "PLS-00630" for one example but not for another similar example

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

Missing right parenthesis in a Create sentence

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

How to connect to oracle database with both password and wallet?

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

Is there a way to create an inline anonymous table in Oracle like in PostgreSQL?

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,

What is 'name' keyword in oracle sql? [closed]

Please explain this 'name' keyword What is it? How we can use it? Syntax?

SpringBoot Liquibase Oracle Junit test case execution fails

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

FDMEE - Load Data Rules using external batch script

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

Effective query than AND operator in SQL

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='

Unable to connect oracle database using cx_oracle from AWS Glue

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

How to Mock QueryAsync using Dapper for unit testing an Oracle stored procedure call which returns a RefCursor

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

Can not safely replay call when trying to assign and use a variable in procedure

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

Custom aggregate function to collapse vertices to SDO_GEOMETRY

I have multi-part polyline vertices stored as individual rows in an Oracle 18c table. ASSET_ID PART_NUM VERTEX_NUM X Y M --------