Differences Between SQL Server & Oracle SQL

<i><b>Originally posted by : Martin Burford (martin_burford@hotmail.com)</b></i><br />Hi there,<br /><br />Does anybody know of any resources available on the internet that details the differences between Oracle SQL and Microsoft SQL Server. I am currently creating ASP applications linking to Oracle Databases, and I need to know the syntax differences when sending/retrieving data from tables when using SQL Server databases<br /><br />Cheers for your help<br />Martin<br />

<i><b>Originally posted by : Chris Goll (chris_goll@hotmail.com)</b></i><br />Hi<br /><br /><br />If you are just running ANSI SQL scripts (rather than stored procedures) on the fly, then the differences are small - as they should be. Recommend just the Oracle on-line doc help and the MS SQL books on-line. Can't point you to any Internet resource.<br /><br /><br />If for speed and security reasons you want to run stored procedures then there are big differences when it comes to returning recordsets. You will need to create Oracle Packages - not just stored procedures. Microsoft KB articles Q174679 and Q174679 are a usefull start for returning recordsets from Oracle packages. <br /><br />If you are returning no data or just parameter values, then you can use Oracle stored procedures. The SQL is fairly similar, but I would recommend the O'Reilly book Oracle PL/SQL.<br /><br />Cheers<br />Chris<br /><br /><br /><br />------------<br />Martin Burford at 6/6/2000 10:42:25 AM<br /><br />Hi there,<br /><br />Does anybody know of any resources available on the internet that details the differences between Oracle SQL and Microsoft SQL Server. I am currently creating ASP applications linking to Oracle Databases, and I need to know the syntax differences when sending/retrieving data from tables when using SQL Server databases<br /><br />Cheers for your help<br />Martin<br />