Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»

Learning Oracle Expand / Collapse
Author
Message
Posted Wednesday, September 19, 2012 9:06 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 22,474, Visits: 30,145
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1361421
Posted Wednesday, September 19, 2012 10:13 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 1,467, Visits: 4,265
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?



"Winter Is Coming" - April 6, 2014
Post #1361478
Posted Wednesday, September 19, 2012 10:22 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 22,474, Visits: 30,145
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1361488
Posted Thursday, September 20, 2012 1:25 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:32 PM
Points: 176, Visits: 527
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.

Back end of Oracle is very configurable and tunable (i.e. you can configure page size) and 'open' but also very complicated, and you need to know a lot of stuff to be able to make a simple change. It suffers from having to maintain a lot of backwards compatability.

Lately I have noticed the Oracle introduces new features (i.e. windowing functions). Messes them up a bit, has to wear the pain to get them right. Then when they've settled down, MS learns from their mistakes and get's it mostly right first time, 18 months later. I'm happy with that because the MS product stays a little cleaner.

SQL is also starting to collect backwards compatability baggage now though.


But compare moving a database file in Oracle with moving a database file in SQL. Oracle is incredibly manual and error prone. SQL gives you a GUI and you don't really need to know all about the guts of it to move a database file.
Post #1361769
Posted Thursday, September 20, 2012 7:32 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 1,467, Visits: 4,265
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.



"Winter Is Coming" - April 6, 2014
Post #1361962
Posted Thursday, September 20, 2012 7:49 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 22,474, Visits: 30,145
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1361984
Posted Thursday, September 20, 2012 9:23 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:32 PM
Points: 176, Visits: 527
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.





Post #1362403
Posted Friday, September 21, 2012 7:17 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 1,467, Visits: 4,265
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.



"Winter Is Coming" - April 6, 2014
Post #1362653
Posted Friday, September 21, 2012 5:40 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:32 PM
Points: 176, Visits: 527
True.
Post #1363045
Posted Friday, February 08, 2013 11:24 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #1417843
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse