you can look in VIEWS or you can use SQL/PS
For the last you can do something like this:

*** DSNLESS Conn
lcHandle=SQLSTRINGCONNECT("Driver={Microsoft ODBC for Oracle};Server=MyDatabase;Uid=IsMe;Pwd=123;")

 ?lcHandle && if -1 then it did not connect

 *** build your sql 
 lcSQL="SELECT one, two,three" +;
	"four,five,six"+ ;
	" FROM Table1"

*** exc the command
	= SQLEXEC(lnhandle, lcSQL+" WHERE one =?whavervevalue","ToCursor")

that's it. You now will have the cursor to create your report.
If you want to "Edit"
then you edit your cursor and send the UPDATE to Oracle the same way.


>Dear all,
>
>Can you please advise me on how I could be able to extract/edit records from an Oracle table. Is it possible to make a report form that could take records from an Oracle table.
>
>Appreciate your assistance.
>
>Thanks.
>
>Ed