Re: Converting MS Access SQL Query With INNER JOIN To Oracle SQL
From: joel garry <joel-garry_at_home.com>
Date: Fri, 10 Sep 2010 09:28:31 -0700 (PDT)
Message-ID: <b0437027-ac69-4190-be89-9bc4f33a5d2f_at_t5g2000prd.googlegroups.com>
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...
Date: Fri, 10 Sep 2010 09:28:31 -0700 (PDT)
Message-ID: <b0437027-ac69-4190-be89-9bc4f33a5d2f_at_t5g2000prd.googlegroups.com>
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-numbers/Received on Fri Sep 10 2010 - 11:28:31 CDT