We have an app that currently is using SQL Server. We've been asked to support Oracle as well.

I have some general questions, and a few specific ones:

1) While much of our SQL Server syntax is ANSI-compliant, we also do a fair amount of CREATE TABLE #TempTable statements. Are temp tables created in Oracle in the same way?

2) Are there any significant differences/challenges in a .NET environment where Oracle would be used instead of SQL Server?

3) We are thinking of developing a lengthy script to create all the stored procs and updated triggers for a SQL Server database. Is there a 'scripting language' that is compatible with both SQL Server and Oracle, so that you can have one long script/text file that could created triggers and stored procs for a database, for both SQL Server and Oracle?

4) Does SQL Pass-Through (SQLEXEC) work as cleanly with Oracle as it does with SQL Server?

5) Last question is more a general one, if anyone has additional advice/web site references/etc for how to construct an app that can use either database.

Thanks in advance,
Kevin