Re: is this a valid sql statement ?

From: <michael_bialik_at_my-deja.com>
Date: Wed, 03 Nov 1999 21:33:08 GMT
Message-ID: <7vq9ml$frp$1@nnrp1.deja.com>

Hi.

It looks OK.
Try running that statement via SQL/PLUS with the values of START and STOP dates.
It may happen that you are making incorrect join in Oracle and the query just takes forever.

HTH. Michael.

In article <7vol6n$9ao$1_at_nnrp1.deja.com>, javanewbie_at_my-deja.com wrote:
> String str1= "select d.state_name, count(*) from " +
> " doctor_master d , foreign_worker_master f " +
> " where f.doctor_code = d.doctor_code " +
> " and (f.creation_date>TO_DATE('" + lbFromDateStart.getText()
> + "','DD/MM/YYYY') and " +
> " f.creation_date<TO_DATE('"+lbFromDateStop.getText()
> +"','DD/MM/YYYY') ) " +
> " group by d.state_name ";
>
> is this a valid sql statement ?
>
> i got a program hanging when i try out the above statement.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 15:33:08 CST