Re: Access Oracle SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Tue, 19 Jul 2005 10:31:02 -0700, Souris
<Souris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I got following errors when I tried your suggest.
>
>SELECT * From MyTable
>WHERE MyField = To_Date(Format(Date(), "mm/dd/yyyy"))
>
>ORA-00936 ERROR
>
>SELECT * From MyTable
>WHERE MyField = "'" & Date() & "'"
>
>ORA-00933 ERROR

I'd suggest you repost, Souris - it's been years since I've used an
Access-Oracle link and I'm not coming up with any good ideas. I don't
have Oracle installed so I cannot help with the Oracle error numbers.

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Access Oracle SQL
    ... "John Vinson" wrote: ... Souris - it's been years since I've used an ... > Access-Oracle link and I'm not coming up with any good ideas. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Thread and Join
    ... Please rewrite your program to use qualtity identifiers. ... Then repost on this group. ... No professional is going to donate/waste his/her ... Prev by Date: ...
    (comp.lang.java.programmer)
  • Re: A Christmas story---by "Merlin"
    ... yeah, that's what I thought. ... enjoyed my posting so much that he decided to repost it under a new ... Prev by Date: ...
    (sci.med.diseases.lyme)
  • Re: PING; Mystikal: Still waiting for your post...if sent, didnt make it :(
    ... Please repost, thanx and ... >> take care! ... that message, VERY sorry I read it wrong, but thank you for clearing me ... Prev by Date: ...
    (comp.security.pgp.test)
  • Re: Criminal Al Franken
    ... Please repost when you have a credible "news" source. ... Posted by the Rubber Dino. ... Prev by Date: ...
    (alt.politics)