?
Solved

ORA-00900: invalid SQL statement

Posted on 2007-03-28
2
Medium Priority
?
658 Views
Last Modified: 2013-12-07
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')

      )
0
Comment
Question by:rufassa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 20

Accepted Solution

by:
gatorvip earned 375 total points
ID: 18810301
Well, for one, you need to convert your date strings to a valid date format. Use the to_date() function.
0
 
LVL 20

Expert Comment

by:gatorvip
ID: 18810313
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).
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question