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