SQL selecting rows by most recent date with two unique columns

Using the following query and results, I'm looking for the most recent entry where the ChargeId and ChargeType are unique. select chargeId, chargeType, serviceMonth from invoice ...

How to select columns from a table which have non null values?

I have a table containing hundreds of columns many of which are null, and I would like have my select statement so that only those columns containing a value are returned. It would help me analyze...

Catch Oracle timeout exceptions

I want to handle timeout exceptions differently from other SQL exceptions, much like https://stackoverflow.com/questions/29664/how-to-catch-sqlserver-timeout-exceptions However, our application...

Oracle - PLS-00103: Encountered the symbol "END" when try to create JOB

i have a problem here, i already have a Stored Procedure called "SP_DEL_TOKEN" and i wanna make a job to run the Stored procedure automatically everyday.. this is my script to make the job VAR...

PL/SQL anonymous block completed with no result displayed

When I execute the procedure nth would appear except the following message and not showing any output which should not be the case: anonymous block completed I've tried to set serveroutput on size...

Oracle flex value hierarchy SQL query for oracle ebs r12 report

I am new to oracle and oracle ebs and I need some help. I am doing a report in oracle ebs r12 and I need to list flex values from fnd_flex_values_vl view in a hierarchical way using a SQL query....

Left Outer Join and Union

I have two tables that have a parent and associated via a foreign key through their parent table, i.e. TableP ----------------- | C1 | P2 | P3 | ----------------- 0 P2 P3 TableA ...

"ORA-14450: attempt to access a transactional temp table already in use" in a compound trigger

I have a table which can hold many records for one account: different amounts. ACCOUNTID | AMOUNT id1 | 1 id1 | 2 id2 | 3 id2 | 4 Every time a record in this table is...

Update and insert records into Oracle table using OracleDataAdapter from DataTable

a question from a newbie to c# and apologies for the lenght of it. I have the following scenario. I have a small console application that populates a datatable by connecting to an external...

Error- ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

I am attempting to read a BLOB message and display it as a variable in one of my procedures, but am getting the error below: Error - ORA-22835: Buffer too small for CLOB to CHAR or BLOB to...

How to pass a date parameter from report builder query designer to oracle database

i'm using report builder 3.0 connected to oracle database. i'm trying to pass a date parameter in the query with no success, i don't know the exact syntax. I've tried : SELECT * FROM...

How do I resolve this "ORA-01109: database not open" error?

I'm trying to create my own database using SQLPlus. So first I log into it as admin: sqlplus sys/sys_password as sysdba And then I try to create a new user, called sqlzoo : CREATE USER sqlzoo...

Oracle.DataAccess.Dll loading issue on x-64 machine

I have a .net exe program which is using Oracle.DataAccess, Version=2.121.1.0 dll. My development machine and tfs build server both are 32-bit. Everything is working fine on 32 machines. But now...

Order by Date in Oracle

Trying to order by as follows: SELECT DISTINCT TO_DATE(e.PUB_DATE_PRINT, 'DD Mon YYYY') AS "Publication Date" FROM TABLE ORDER BY e.PUB_DATE_PRINT DESC I'm getting an error here because of the...

How to use encrypted password in connection string of sqlalchemy?

I'm working with sqlalchemy and oracle, but I don't want to store the database password directly in the connection string, how to store a encrypted password instead?

Why I do not need semicolon after some of Oracle SQL commands?

I encountered interesting behavior in SQL*Developer. Since I am preping to an exam I would like to understand some inconsistencies related to requirement of semicolons. As you know - Oracle DB in...

How to insert a zero instead of a NULL in oracle?

How to insert 0 in place of null? Is this correct INSERT INTO TEMP(ID,NAME) SELECT ID,NVL(NAME,0) FROM TEST;

Where i can find Scheduled Jobs in Oracle SQL Developer?

Need to know following points: Where to locate Scheduled jobs in Oracle SQL Developer? How to remove default date format from SQL Developer.

Python cx_Oracle error "DPI-1047: Cannot locate a 32-bit Oracle Client"

How fix this error, I use python3.6 and I use Oracle database 11g, I want to connect my python to oracle database, but shows error, how can I fix it? This is my code: #importing module import...

Biztalk unable to read Oracle 18 stored procedure with strongly typed ref cursor

We have Biztalk to read data from a table in Oracle by calling a stored procedure. The stored procedure returns a strongly typed cursor and it was working fine with Oracle 12. Updating to Oracle...

entity data model wizard crashes with oracle connection

When trying to create model with entity frameowrk database first method, the entity data model wizard crashes. I am trying to connect to oracle database. Oracle.ManagedDataAccess version...

Oracle 19c and "no valid ip address returned for the host"

I installed oracle 19c on centos 8, there was an error during installation when configuring the listener. Manually running Net Assistance (/bin/netca) and trying to add a listener ends with a...

ODI Why not show Unique Key as option for incremental or merge (why PK only)?

When doing a mapping in ODI, when we are going to perform an incremental load it gives me the option to only use Primary Key (PK), but we use the PK in the table's unique identifier columns (the...

Hibernate QueryException Named parameter not bound error

I keep getting the error org.hibernate.QueryException: Named parameter not bound : item when I start my transaction in JPA using EntityManager createNativeQuery. I have my code below utilizing...

ROracle on R Version 4.0.0

When trying to use ROracle I get the following error message > library("ROracle") Error: package or namespace load failed for ‘ROracle’: package ‘ROracle’ was installed before R 4.0.0:...

how to install oracle database express on mac m1

I want to Install Oracle Database Express on macbook m1 but it only supports linux and windows, I downloaded Sql developer but I m unable to download Oracle database. I tried to install using...

Generate WHERE clause from resultset ids?

In Toad for Oracle 12: I've selected rows from a table using a complex query. I want to select those same rows in the system's application's WHERE clause. However, the application doesn't support...

Oracle 12c docker setup on Apple M1

I am trying to run Oracle db in docker on M1 Mac. I have tried images from both store/oracle/database-enterprise:12.2.0.1-slim and container-registry.oracle.com/database/enterprise:12.2.0.1-slim...

Docker / Oracle Database / Change Port 1521

I have set an Oracle docker image (https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance/dockerfiles) which by default is running on port 1521. I would like to change...

wk buffer error when running .get_WKT Oracle Spatial function on SDO_GEOMETRY objects

My company runs Oracle 19 and we recently (October 25) installed the October Oracle quarterly patch. Since the patch was applied, I have been unable to run the .Get_WKT function without frequently...