home
I am trying to figure out why I am getting this error message. I have tried revising the code in...
I want compare my Oracle production and test environment using python. I have limited python...
We have a query that takes 48 minutes to run a search on a clob. The query is written as if it is...
I have been working on a class assignment and for some reason the only one i can not solve is a...
i have a table test which contains all the table names , column_names and flag . i want to create...
We have a Oracle forms 12c application that is launched using FSAL. The launch script looks like...
Wrote this SQL and just need some help how to show the last WO created date on my sql. I tried the...
Say I have several tables that all start with 'PLAYER_' and I am trying to loop through all of...
I'm new to IIS, I'm trying to mount a web application on the IIS of the server, but at the moment...
SQL to oracle conversion of outer apply. I have the following SQL query : CREATE VIEW...
I am trying to convert the below string value to TO_DATE but oracle is not recognizing the date...
I have the following schema and built a query with 2 pivots sqlfiddle select * from (select *...
I'm working on a project in Oracle Commerce Cloud (OCC). I'd like to create a new stand-alone...
6 hours ago

SQL : Sum by criteria

I'm working with Oracle and cannot achieve the query I need for the moment. Suppose I have the...
I have the following issue. I thought that the query was correctly created but I have just verified...
I have problems to refresh the structure of a table in my universe. We have added some data to a...
I'm currently start working on a project (just got the requirements) and our company has a huge...
I couldn't find any easy of doing table update with value from left join. I want to do something...
We have a report on BIP that shows data based on three parameters. One of these is date parameter....
I want to know WHO(which user) refreshed a materialized view that has REFRESH_MODE as DEMAND ...
I am using Oracle SQL to extract the data; I have supply periods for IDs in 2 systems. I have this...
This question is new twist of An IF inside a check constraint SQL. I want to do something similar...
I am trying to install Oracle client 11gR2 ( win64_11gR2_client.zip ) on a MS Windows...
CREATE OR REPLACE TRIGGER "BI_FILM_LANG" BEFORE INSERT ON "FILM" FOR EACH ROW BEGIN SELECT...
9 hours ago

Oracle row wise Sum

My Oracle Employee_Expense table is as follows. Text in red is what I am expecting. I just need...
I'm looking to confirm if you partition the partitioning of Oracle data will also have an affect to...
I am working on a springboot application which contains two database connections.. one is Mysql...
I'm using Entity Framework Core 2.1.4 with Oracle 11 database and Devart.Data.Oracle.EFCore...
I need connect to oracle with python. The oracle mode is RAC mode´╝łoracle cluster). My code: dsn...
I have an existing Oracle database table in which BLOB field contains files, I want to extract the...