Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Question on PL/SQL statement.
Hi,
I inherit the following PL/SQL statement:
EXEC SQL SELECT COUNT(*) INTO :rowcount FROM MY_LIST L1, MY_LIST L2 WHERE L1.key_no = L2.key_no AND L1.supply_code = L2.supply_code AND L1.batch_id = '1' AND L1.send_delete_ind = 'Y' AND L2.batch_id = '1' AND L2.send_delete_ind = 'N';
I don't understand why it needs L1 and L2. Is the above code the same as the following:
EXEC SQL SELECT COUNT(*) INTO :rowcount FROM MY_LIST L1 WHERE L1.send_delete_ind = 'Y' OR L1.send_delete_ind = 'N';
Thanks in advance!
feilip
Received on Tue Jun 13 2006 - 21:36:01 CDT