Hi Satya ---

Sounds like, in your case, you are best served with remote views of the Oracle data and, therefore, you can process queries with VFP commands. By setting the view/field updateable properties you can pass data back to Oracle. Look out for Oracle columns with sequence constraints, though, don't try to update those.


>I have an ORACLE server. I want to create a table in ORACLE with the structure of the table I have for a Foxpro table.
>
>I am using string concateanations and some progeam logic to create a query and then pass it to the SQL Plus by issuing command SQLEXEC.
>
>Is there a better way of doing it ?
>And a way of updating table in ORACLE with FOX data.
>
>Like you create remote views of ORACLE data on FOxpro.
>I DON'T WANT the ORACLE UPSIZING WIZARD.