>Hi all!
>
>Can someone give me a hint on how different Oracle-SQL is compared to Microsoft SQL?
>
>AFAK Oracle doesn't support inner-/left-/right-joins - only full joins. Is this info right?
>Are there any differences in using Group-By, Union,Create table,...
>
>Thanks for help.

Robert,
Oracle does support both inner and outer joins. The syntax is different. Where VFP and SQL Server use the keyword(s) LEFT|RIGHT OUTER JOIN, Oracle uses the (+) sign to designate an outer join. Ex.

select a.field1, nvl(b.field2) 
   from table1 a, table2 b
   where a.field1 = b.field1(+)

This is a left outer join.

You can't use create table in an Oracle procedure/function/package. You have to use dynamic SQL to handle situations like this (see EXECUTE IMMEDIATE).

HTH.