Hi All,
I have written 4 SQL queries. I want to write PRO*C program for this. I want to put these 4 queries in a single PR*C program using threading concept. Please guide me to write the pogram.
the queries are as follows.
1. select * from head;
2. select * from details;
3. delete from head where <condition>
4. delete from DETAIL where <condition>

I want to write a cursor for this like
Cursor C! is
select * from head;
curosr c2 is
select * from detail;
...
IF c1 % found then
delete from head;
IF c2% found then
delete from detail;
....



Thank you.