Results 1 to 2 of 2

Thread: Switching to Oracle

  1. Feb 11th, 2005, 07:43 AM #1
    zubairkhan
    zubairkhan is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2002
    Location
    Pakistan
    Posts
    436

    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
    Reply With Quote Reply With Quote
  2. Feb 11th, 2005, 07:47 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Switching to Oracle

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width