2 Replies Latest reply: Dec 25, 2012 11:09 AM by 981588 RSS

    New To Oracle

    981588
      Hello Forum,
      I am a sql server guy and have to make the change to oracle for work reasons
      I am a software engineer not a dba, but I still need to interact with oracle
      I have access to toad, oracle 11g

      What I need is a starting point for reference.
      I am looking for a beginner to intermediate guide to oracle to include the syntax, and other complex operations
      another guide for toad, pl/sql,
      and if this exists a guide that is designed for the transition from sql server to oracle

      So far after spending some time goggling I have found a lot of oracle admin books, but the tend to skip the basics including syntax which is important as there are big differences between the two languages
      example> in sql server I can have an auto increment identity column in a table, but in oracle this does not exist but rather uses some kind of system sequence -- I have sort of figured this out but still would like a reference to it

      can anyone recommend a book or a list of books that might get me started in the right direction

      thanks to any who can help
        • 1. Re: New To Oracle
          yoonas
          Hi,

          You can start with http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e25789/toc.htm to have a better understanding of how oracle server works


          http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/toc.htm

          http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e26088/toc.htm

          Regards
          Yoonas
          • 2. Re: New To Oracle
            981588
            Thanks for those links, they were exactly what I was looking for
            best wishes

            Nathan