<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Working with Oracle
»
Learning Oracle
51 posts, Page 5 of 6
««
«
2
3
4
5
6
»»
Learning Oracle
Rate Topic
Display Mode
Topic Options
Author
Message
Lynn Pettis
Lynn Pettis
Posted Wednesday, September 19, 2012 9:06 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:02 AM
Points: 21,596,
Visits: 27,415
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
Eric M Russell
Eric M Russell
Posted Wednesday, September 19, 2012 10:13 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 1,162,
Visits: 3,333
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?
"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47
Post #1361478
Lynn Pettis
Lynn Pettis
Posted Wednesday, September 19, 2012 10:22 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:02 AM
Points: 21,596,
Visits: 27,415
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
nick.mcdermaid
nick.mcdermaid
Posted Thursday, September 20, 2012 1:25 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 7:09 PM
Points: 160,
Visits: 425
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
Eric M Russell
Eric M Russell
Posted Thursday, September 20, 2012 7:32 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 1,162,
Visits: 3,333
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.
"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47
Post #1361962
Lynn Pettis
Lynn Pettis
Posted Thursday, September 20, 2012 7:49 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:02 AM
Points: 21,596,
Visits: 27,415
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
nick.mcdermaid
nick.mcdermaid
Posted Thursday, September 20, 2012 9:23 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 7:09 PM
Points: 160,
Visits: 425
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
Eric M Russell
Eric M Russell
Posted Friday, September 21, 2012 7:17 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 1,162,
Visits: 3,333
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.
"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47
Post #1362653
nick.mcdermaid
nick.mcdermaid
Posted Friday, September 21, 2012 5:40 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 7:09 PM
Points: 160,
Visits: 425
True.
Post #1363045
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Friday, February 08, 2013 11:24 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 1:08 PM
Points: 2,982,
Visits: 4,396
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 »
51 posts, Page 5 of 6
««
«
2
3
4
5
6
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
