Forums Register Login

PL/SQL Question

+Pie Number of slices to send: Send
Suppose a database table has these columns: column a, column b, column c, column d, column e, and column f.

How would I write PL/SQL code to represent this condition?

if (column a is null and some other column in the same row is not null)
+Pie Number of slices to send: Send
I don't have an Oracle DB to test with, but possibly:

a IS NULL and coalesce(b,c,d,e,f) IS NOT NULL
I like you because you always keep good, crunchy cereal in your pantry. This tiny ad agrees:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 443 times.
Similar Threads
long post IBM.158
looking for a graphical representation
Connection Array into an adjacency Matrix
SQL injection?
Trouble with model for calculating and adding table values dependent on multiple rows
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 08:23:59.