Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> can i execute this sql ?

can i execute this sql ?

From: <newnewbie_at_my-deja.com>
Date: Thu, 28 Oct 1999 07:48:28 GMT
Message-ID: <7v8v4c$cpd$1@nnrp1.deja.com>

    String str1= "select e.state_name, fwm.job_type, fc.fit_ind, count (*) from EMPLOYER_MASTER e, " +

" FOREIGN_WORKER_MASTER fwm, FW_CERTIFIED_DETAILS fc "+
" where fwm.employer_code = e.employer_code and " +
" fc.worker_code = fwm.worker_code group by e.state_name,
fwm.job_type, fc.fit_ind " ;

the code for my sql is as above.

can i execute it ?

when i try, the program just hangs. perhaps there is too many records ?

thanks, bye.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 02:48:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US