Can someone help me interpret a sql query please

[Matt Kohanek]

The query is:
SELECT cat_code, start, end FROM OTA WHERE transaction_id = :order_id and Transaction_code = 'ORDER' and NVL(ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);
The portion that I am having trouble interpreting is the last and
and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);
What is the last and wanting ORG_ID to equal (or not equal)?


Or a little help on how to interpret this myself would work too. How would I break this down into smaller parts to evaluate from the inside out? I will figure it out with more time, but would definitely like some assistance if anyone is willing.

[Andrew Monkhouse]

Hi Matt

I split your SQL into multiple lines, and added indentation so that it is hopefully a little clearer what is being compared.

Does this help?

[Matt Kohanek]

Yes, very much. I should have tried to do that myself, I was just feeling lazy at the time because I had been at debugging for about 10 hours straight.

Thanks for humoring my laziness