SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Learning Oracle


Learning Oracle

Author
Message
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)

Group: General Forum Members
Points: 95667 Visits: 38968
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.

Cool
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)
Eric M Russell
Eric M Russell
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29198 Visits: 11517
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?


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)

Group: General Forum Members
Points: 95667 Visits: 38968
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.

Cool
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)
nick.mcdermaid
nick.mcdermaid
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 782
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.
Eric M Russell
Eric M Russell
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29198 Visits: 11517
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.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)

Group: General Forum Members
Points: 95667 Visits: 38968
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.

Cool
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)
nick.mcdermaid
nick.mcdermaid
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 782
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
Eric M Russell
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29198 Visits: 11517
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.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
nick.mcdermaid
nick.mcdermaid
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 782
True.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search