Re: Export Table Using QUERY Parameter with Dates

melliott42_at_yahoo.com wrote:
> Hello,
>
> In Oracle9i on Sun Solaris 8 can someone please post an example of
> doing an export using the QUERY= parameter using a date range.
>
> The docs I have found have examples of text but no date examples and
> the syntax for QUERY= seems a bit tricky as you need control characters
> in some cases etc.
>
> For example how would this be implemented:
>
> SELECT to_date('2002-07-01','YYYY-MM-DD') FROM history
> BETWEEN to_date('2002-07-01','YYYY-MM-DD') AND
> to_date('2002-09-30','YYYY-MM-DD');
>
>
> Thanks very much,
>
> Michael

I've never used the QUERY on an export, but I see that your query is fundmentally flawed. You never actually specify a column in the table history, and there is no WHERE clause ..... Received on Sat Oct 15 2005 - 16:32:34 CDT