Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help tuning a sql statement (SOLVED)

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey there,

So I have the following SELECT:



I have need of some new data, so I have added the following to get what I need out of it:



Basically that last line is all that matters i think. Is there a way to make that all boolean (AND, OR), rather than needing to use NVL? I am sure it is possible, I just have not figured out how.

Thanks


solution - this worked

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic