I am having trouble adding a percent sign to the output of the NVL() function. If you look in the desired output picture you will see that the commission needs to have a % added to it. I’ve tried various things but have been unable to get it to output correctly. I have tried concatenating a percent sign…
Tag: oracle
Split row data base on timestamp SQL Oracle
Good day everyone. I have a table as below. Duration is the time from current state to next state. Timestamp State Duration(minutes) 10/9/2022 8:50:00 AM A 35 10/9/2022 9:25:00 AM B 10 10/9/2022 9:35:00 AM C … How do I split data at 9:00 AM of each day like below: Timestamp State Duration(minutes) 10/9/…
SQL : instead of using a union want to use a where clause but one of the clauses is only true if another clause is true
I would like to not use a union in my SQL query – how can I rewrite the following query? How can I rewrite this without the union? Answer Use Boolean logic: If you are combining with other conditions then make sure you have the correct parentheses to make it evaluate properly, e.g.: … so you aren&…
How do I select unique values in a single column with multiple column selected?
the query is actually fine and running but it doesn’t select distinct the column A.CONTRACT_NUMBER. This is the code: It runs normally but after checking the data, there are still repeated values in the A.CONTRACT_NUMBER column. A.CONTRACT_NUMBER is like the primary key column and I’d like to sele…
Can a CLOB column containing objects be sorted?
I have a column type CLOB that stores an array of objects containing the following structure: {“id”: number, “name”: string} Then suppose we have the following column of CLOB records: [{“id”: 21, “nombre”: “fisica”}, {“id”: 16, “nom…
Is it possible to have a nested where and and clause in oracle sql?
I’ve tried search for this and I’m not sure I’m using the correct terminology, but is it possible to have a nested WHERE AND clause?: So the nested AND would “and (age != 18 and hair_colour != black)” so you could have: first_name = ‘Jay’ evaluate to true last_name = …
Oracle chr() diferent returns from SQL engine versus PL/SQL engine, why?
Same function, same argument, different outputs: PL/SQL procedure successfully completed. Answer In your case, chr() appears to be performing an implicit conversion to binary_float (IEEE 754 floating-point representation) as the datatype, as opposed to number (ANSI SQL NUMERIC). This results in different roun…
Oracle SQL – Create Sequence and add sequence values on new column
I have the following table called table_1 I create a new column_3 then I create a sequence CREATE SEQUENCE “sequence_1” MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOPARTITION and I alter the table_1 so the default for new values on column_…
Why are these 2 queries giving different outputs?
Query no 1:- The Query 1 gives me the following output:- Query no 2:- The Query 2 gives me the following output:- Answer Summary: The AND operator has higher precedence than the OR operator. To fix it, use brackets around the OR expression. AND has higher precedence than OR so your first query is the equivale…
Evalaute Oracle Table to Calulate or Extend Multiple Date Ranges into One Period
I have a table that shows date ranges of an object. For reference The object needs some sort of event in order to prevent it from expiring. We have a rule where we can apply a protection against the object from expiring, so that there is no need to action the object. The date ranges are a period of time