Database query

[Gaurav]

Hi All,

I have a database query written in shell script as :

ORACLE_SID = "$dataenv"

insert into unizzz.job
select cu.user_id||wg.job_code||wg.subsystem,
cu.user_id,
wg.job_code,
' ',
wg.subsystem,
to_number(to_char(sysdate,'dddHHMIsssss')) + rownum || '01'
from nmclas.clas_users@$refenv cu,
nmclas.work_group@$refenv wg
where cu.work_grp=wg.work_grp and
cu.user_id=upper(rpad('khalnayak'),8))



Please note that I have logged in to the ORACLE_SID as dataenv, but I
search in some other database stored in the variable refenv.

Now how can I port this query in java ?

Considring I open a connection to dataenv, but can I still reuse the
same query which has got a reference to another database "refenv" ?

Regards,
Gaurav