>Got 2 questions:
>
>1. Is there an equivalent field type in Oracle to the Foxpro's LOGICAL?.

No. You could use a numeric data type of width 1 and use 0 for False and 1 for True.

>2. I have a SQL statement which combines a local cursor already SQLed from the back-end and need to re-use on a 2nd SQL. How can I use this?.
> Select * from table1 where filter1 into cursor cursor1
>
>
> Select * from table2 where table2.code in (Select name from cursor1)
>
>Thanks for the responses.

You can not do this. You need to submit subquery:

Select * from table2 where table2.code in (Select table1.code from table1 where filter1)

Use SQLExec function to return the results to a cursor.