rufassa
asked on
ORA-00900: invalid SQL statement
Why is this not being excepted?
Select
*
From
tmoadm.dat01 d1,
tmoadm.dat02 d2
Where
rownum < 15 AND
d1.LOAN_NUM = d2.LOAN_NUM AND
(
(d2.application_date >= '01/Jan/2007' And
d2.application_date < '02-Jan-2007')
OR
(d2.FUNDING_AMOUNT >= '01/Jan/2007' And
d2.FUNDING_AMOUNT < '02-Jan-2007')
)
Select
*
From
tmoadm.dat01 d1,
tmoadm.dat02 d2
Where
rownum < 15 AND
d1.LOAN_NUM = d2.LOAN_NUM AND
(
(d2.application_date >= '01/Jan/2007' And
d2.application_date < '02-Jan-2007')
OR
(d2.FUNDING_AMOUNT >= '01/Jan/2007' And
d2.FUNDING_AMOUNT < '02-Jan-2007')
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
gatorvip
Also, are you sure that FUNDING_AMOUNT is really a date as it appears to be in your code? It's misnamed, in that case (imo).