Switching to Oracle

Dear friends i switched to SQL server from Access it was very easy just because of ADO. Now my organizaition decided to switch to Oracle, i did't work in oracle, but here i want to know if once i create the connection with oracle database, wether the rest of recordset coding will remain same or not?

thanks

Quote:

---

Originally Posted by zubairkhan

Dear friends i switched to SQL server from Access it was very easy just because of ADO. Now my organizaition decided to switch to Oracle, i did't work in oracle, but here i want to know if once i create the connection with oracle database, wether the rest of recordset coding will remain same or not?

thanks

---

For the most part, yes - there are differences in writing SQL for SQL Server and PL/SQL for Oracle, but they aren't really drastic differences and are very easy to pick up. PL/SQL also has some pretty neat reserved words that SQL Server does not, like TO_DATE and DECODE.