Learning Oracle

  • Lynn Pettis

    SSC Guru

    Points: 442116

    Eric M Russell (9/20/2012)


    Lynn Pettis (9/19/2012)


    Eric M Russell (9/19/2012)


    Lynn Pettis (9/19/2012)


    tutblog1 (9/19/2012)


    Want to learn SQL?

    Goto

    easysqlguide.blogspot.in

    Easily learn SQL with the help of images.

    Two year old thread, and no, I don't want to learn SQL from your blog. I already know SQL.

    So, after two years, how what's your overall impression of Oracle versus SQL Server?

    Only worked with Oracle for a year. I am GLAD to be back working with SQL Server. There are a few things that I liked about Oracle, but I really think SQL Server does more things in a better way. Could be 15+ years of using SQL Server talking there.

    In Oracle, an empty string is null ('' IS NULL), and consequently an empty string is not equal to itself. This evaluates as False: ('' = ''). For those of us who speak Oracle SQL as a second language, that can result in some bugs that are very subtle and hard to track down. I can live with proprietary functions and even minor syntax differences between SQL implementations. However, I just can't get past the fact that a major database vendor would have the default definition of NULL not conform to ANSI standard. As far as I know, there is no equivalent to a "SET ANSI_NULL ON" setting etiher.

    Another observation is that (this is just my opinion), because Oracle is such a configurable RDMS platform and also contains so much legacy baggage, Oracle developers are not as well rounded on their own platform as SQL Server developers are. They learn how to implement something one way, but there may be 3 or 4 ways of doing it under Oracle. There are also tons of configuration settings, many of which have security implications, that the average Oracle DBA is not aware of. In contrast, SQL Server has a much smaller area of exposure, and for that reason is generally considered more secure out of the box.

    In Oracle, an empty string is null ('' IS NULL), and consequently an empty string is not equal to itself.

    This bit me when I first ran into it when writing code. Of course the Oracle documentation also says this behaviour may change in future versions of Oracle. Personally, the empty string is not the same as null.

  • nick.mcdermaid

    Hall of Fame

    Points: 3779

    If you are lucky you will never have to craft an Oracle Update statement that updates based on another table. Hideous.

    There is no way they will ever change '' IS NULL because a lod of applications will break.

  • Eric M Russell

    SSC Guru

    Points: 124967

    nick.mcdermaid (9/20/2012)


    If you are lucky you will never have to craft an Oracle Update statement that updates based on another table. Hideous.

    There is no way they will ever change '' IS NULL because a lod of applications will break.

    Oracle could provide an ANSI_NULL server or session setting.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • nick.mcdermaid

    Hall of Fame

    Points: 3779

    True.

  • PaulB-TheOneAndOnly

    SSC Guru

    Points: 66773

    nick.mcdermaid (9/20/2012)


    In Oracle, client tools are painful. You need to buy TOAD for a GUI, and has some good features (CTRL-Clkick to get table info) but it's basically a dogs breakfast.

    SQL Developer is a free GUI by Oracle that pretty much does all that is needed - also, web based OEM is pretty good and offers stuff I have not seen in any other GUI like the capabiltiy to run and check AWR reports, real time tracing, etc.

    TOAD is pretty bad at closing connections, I know production environments where it has been banned.

    If looking for a third party GUI I would go with DBArtisan.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Eric M Russell

    SSC Guru

    Points: 124967

    PaulB-TheOneAndOnly (2/8/2013)


    nick.mcdermaid (9/20/2012)


    In Oracle, client tools are painful. You need to buy TOAD for a GUI, and has some good features (CTRL-Clkick to get table info) but it's basically a dogs breakfast.

    SQL Developer is a free GUI by Oracle that pretty much does all that is needed - also, web based OEM is pretty good and offers stuff I have not seen in any other GUI like the capabiltiy to run and check AWR reports, real time tracing, etc.

    TOAD is pretty bad at closing connections, I know production environments where it has been banned.

    If looking for a third party GUI I would go with DBArtisan.

    Oracle SQL Developer is an OK tool, and it can even support connections to a few other database engines like SQL Server, MySQL, and MS-Access. However, it's not as polished as SQL Server Management Studio. SQL Developer is written in Java, which I guess is a plus for some people who develope across different client platforms, but like most all Java apps I've found the tool to be sluggish and occasionally hang.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 6 posts - 46 through 51 (of 51 total)

You must be logged in to reply to this topic. Login to reply