This porting is creating some big problem.
1) In SQL Server I use queries like SELECT INTO table1 FROM SELECT....
This is not possible in Oracle and I've found the new sintax CREATE TABLE table1 AS SELECT.... but this query, when I run it inside my program written in VB6, block the program. Idem if I run the query on Scratchpad in Enterprise Manager. Instead it's all ok if I run the query on SQLPlus.
2) Some simple query (SELECT!!) blocks the program, istead if I run ti on Scratchpad it's all ok.
3) IN SQL Server i can use DELETE FROM table1 FROM SELECT table1 INNER JOIN table2 WHERE... this is not possible in Oracle. There is a similar query?

Regards,
monny