This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PL/SQL Question

 
Fred Victa
Ranch Hand
Posts: 190
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: 3002
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