Re: Converting MS Access SQL Query With INNER JOIN To Oracle SQL

From: <takveen_at_gmail.com>
Date: Fri, 10 Sep 2010 09:54:17 -0700 (PDT)
Message-ID: <55ece225-6afb-4f5c-8858-90a9f19ac29f_at_v23g2000vbi.googlegroups.com>

On Sep 10, 12:28 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Sep 10, 8:17 am, "takv..._at_gmail.com" <takv..._at_gmail.com> wrote:
>
> >http://www.progneer.com/wp/information_more_public.aspx?search_fd0=13...
> > "Moreover, in MS Access using dates is very simple and straight-forward, all you have to do is to surround the date by # (hash symbol) but in Oracle SQL to use the date in the WHERE clause you have to use the TO_DATE function."
>
> WTF???  No, I don't.
>
> select count(*) from sales_order_headers where order_date > '01-
> jan-2010';
>
>   COUNT(*)
> ----------
>       3740
>
> update employee_separation set termination_date = (select sysdate from
> dual) where idiot_name='TAKVEEN';
>
> jg
> --
> _at_home.com is bogus.http://www.signonsandiego.com/news/2010/sep/08/making-sense-housing-n...

The link you referenced in your reply is wrong and deprecated. Here is
correct one:

http://www.progneer.com/wp/information_more_public.aspx?search_fd0=132496 Received on Fri Sep 10 2010 - 11:54:17 CDT