• Post Reply Bookmark Topic Watch Topic
  • New Topic

PL/SQL Question

 
Fred Victa
Ranch Hand
Posts: 192
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
Greg Charles
Sheriff
Posts: 3012
12
Firefox Browser IntelliJ IDE Java Mac Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!