Connect two tables with SUBSTR function
I want to have a complex SUBSTR in where caluse, but got the error.
ORA-00932: inconsistent datatypes: expected – got CLOB
How to identify rows that add up (sum) to a specific amount
I am trying to identify rows in a specific dataset with a dollar amount column that sum up to a specific amount. I know the amount and the amount of rows that add up to that amount.
Creating Variable to Substitute in Table Name
I am working with table names that include the date in this format: “yyyymmdd” in SQL Developer. For example, a table will be called “OMR_CM.ccsi_mbr_id_did_20240314”. Currently, I have a variable that has to be changed each time the code is run to call the date. The variable is set with the script below:
How to exclude values that have a percentage sign (%) in Oracle SQL
So I have a query that brings in a column like the example below
How to populate date into separate columns using row number values
Iam using case statement but unable to achieve the results ( as below)
case when rownum=1 then DATE else ‘null’ end as Col1,
case when rownum=1 then DATE else ‘null’ end as Col2,
New ‘Role’ column based on values
I am looking to have a new column created called ‘ Role’ to show the persons role in the company. People can change roles and the role is based on the cost centre and site they are at.