JDBC - Oracle - Procedure/Fonction
- From: bouchia.nazha@xxxxxxx
- Date: 20 Mar 2007 08:53:48 -0700
Hello
It's possible via JDBC to execute function like this or to execute sql
script:
begin
for dd in (
SELECT id idf
FROM ma_table
WHERE etat= 'A' )
loop
UPDATE ma_table
SET etat = 'T',
WHERE id = dd.idf;
end loop;
commit;
end;
Thanks
.
- Follow-Ups:
- Re: JDBC - Oracle - Procedure/Fonction
- From: David Harper
- Re: JDBC - Oracle - Procedure/Fonction
- Prev by Date: Re: how to convert JAVA string in "hh:mm dd/mm/yyyy" to sql datetime format?
- Next by Date: Re: how to convert JAVA string in "hh:mm dd/mm/yyyy" to sql datetime format?
- Previous by thread: how to convert JAVA string in "hh:mm dd/mm/yyyy" to sql datetime format?
- Next by thread: Re: JDBC - Oracle - Procedure/Fonction
- Index(es):