Finding Null
Sometimes I get extra rows added to a table that I don't want.
I can identify these rows because the invnbr (Invoice Number) is NULL.
I have tried to identify these rows with code like:
SELECT COUNT(ITEM) FROM Invoices01 AS V1 WHERE invnbr = 'NULL';
But this code does not seem to work.
How should this be written?
Mike
Subject
Written By
Posted
Finding Null
March 14, 2023 01:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.