Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL Server to Oracle

  • 25-10-2011 8:39am
    #1
    drag0n79
    Registered Users, Registered Users 2 Posts: 197 ✭✭


    Hi,
    Has anyone got any tips for a very experienced SQL Server programmer/administrator moving to Oracle? Any books/resources that would help the transition?

    Thanks


Comments

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Orafaq.Com is pretty good (though admittedly, I haven't read it in a while).

    Are you going for Oracle admin or dev? Big difference :)


  • #3
    drag0n79
    Registered Users, Registered Users 2 Posts: 197 ✭✭drag0n79


    Tom Dunne wrote: »
    Orafaq.Com is pretty good (though admittedly, I haven't read it in a while).

    Are you going for Oracle admin or dev? Big difference :)

    Thanks.
    Development (...for now. It depends on what I'm needed for in future I guess).


  • #4
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Oracle PL/SQL programming from O'Reilly is a good book. Assuming you are developing in PL/SQL, are you?

    One tip I would give you is about this great fear of Oracle. Some kind of aura around it that people just don't want to know about. Lose that fear. It's not really much different from any other piece of software when you get down to the nuts and bolts of it.

    Yes, it's horribly complex, yes it has a lot of baggage, but if you can become proficient in it, I am told there is good money to be made (I never made the big bucks because I jumped to academia :( ).


  • #5
    DublinWriter
    Registered Users, Registered Users 2 Posts: 9,560 ✭✭✭DublinWriter


    asktom.oracle.com

    - great for specific problems/questions.


  • #6
    Collumbo
    Registered Users, Registered Users 2 Posts: 180 ✭✭Collumbo


    i used this a lot and it's pretty good.

    http://www.techonthenet.com/oracle/

    Just be aware that some things in pl/sql are very different to the approach you would take with t-sql. I switch between the two quite a lot and go rusty on whichever one I'm not using.. takes me about a day to get back into the groove of the one I've been away from one for a while!

    Download the free copy of TOAD and make sure you solve your tnsnames.ora crap especially if you have multiple versions of oracle client installed before you go any further. That will save you an awful lot of pain long term.


  • Advertisement
Advertisement