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 «««12345»»»

Learning Oracle Expand / Collapse
Author
Message
Posted Wednesday, October 13, 2010 2:25 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258, Visits: 494
Lynn Pettis (10/13/2010)
harrifolfenced (10/13/2010)
what are advantages of oracle over sql


In my opinion, nothing. Both serve a purpose and can do the job.

In the short time I have had with Oracle, however, I definately prefer MS SQL Server. I could be biasedn howevern having worked with SQL Server for 12+ years and Oracle only a couple of weeks.


But there must be something that makes you say that... what in particular struck you?


Random Technical Stuff
Post #1003972
Posted Wednesday, October 13, 2010 3:18 PM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 12:40 PM
Points: 1,477, Visits: 4,281
harrifolfenced (10/13/2010)
what are advantages of oracle over sql

SQL Server is to Windows what Oracle is to Unix. Oracle has been around since the 70s or early 80s, and it carries a lot of legacy pre-ANSI SQL baggage. There is a much larger body of proprietary knowledge to learn, a lot more switches to tweak, and the impression I get is that there are more Oracle developers but fewer Oracle experts.
On the other hand, SQL Server is newer and will deprecate features that become obsolete (a good thing in my opinion), making it a much cleaner and easier to learn. Go to Barnes & Noble or Borders, browse the books on Oracle 11g and SQL Server 2008, then decide for yourself which speaks to you.



"Winter Is Coming" - April 6, 2014
Post #1003999
Posted Wednesday, October 13, 2010 3:38 PM


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
harrifolfenced (10/13/2010)
what are advantages of oracle over sql

Let me point to just two differences that some people may construct as Oracle advantages.

Oracle runs on multiple O/S
SQL Server runs only on top of WinTel while Oracle would run even in a blender if you can put on it anyone of a wide variety of O/S including but not limited to Windows, Unix, HP-UX, IBM-AIX, Linux, Solaris, etc.

Oracle RAC
Oracle RAC is a functional, reliable high-availability solution. There is nothing like Oracle RAC in SQL Server

Hope this helps.


_____________________________________
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 #1004010
Posted Wednesday, October 13, 2010 3:51 PM


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
Eric Russell 13013 (10/13/2010)
On the other hand, SQL Server is newer ...

Always remember SQL Server carries Sybase genes; don't look at SQL Server 4.0 as SQL Server date of birth


_____________________________________
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 #1004016
Posted Wednesday, October 13, 2010 3:55 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 4:33 PM
Points: 22,492, Visits: 30,193
In my opinion, both Oracle and SQL Server have their place. What I have seen, however, is that the decision to use one over the other is usually dictated by "politics" more than what is the best tool for a particular application or environment. It seems to me that SQL Server can handle many of the environments that Oracle is used and do so at a lower cost. I have seen that Oracle has reduced licensing costs over the past 10 years, but SQL Server still costs less and provides more out of the box.

That said, there will still be places where Oracle may make better sense, such as where RAC is needed.
Bottom line, use the tool that makes sense technically and fiscally, not just politically.




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 #1004022
Posted Wednesday, October 13, 2010 4:45 PM


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
Lynn Pettis (10/13/2010)
In my opinion, both Oracle and SQL Server have their place. What I have seen, however, is that the decision to use one over the other is usually dictated by "politics" more than what is the best tool for a particular application or environment. It seems to me that SQL Server can handle many of the environments that Oracle is used and do so at a lower cost.


I couldn't agree more.


_____________________________________
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 #1004047
Posted Wednesday, October 13, 2010 7:38 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:46 PM
Points: 35,959, Visits: 30,250
ta.bu.shi.da.yu (9/17/2010)
2. Oracle has implemented more of the SQL standard that Microsoft. Case in point: try doing a lag, lead, or top analytic function in SQL Server... you can't! You can only use rank, denserank, and row_number. If you were able to use lag(column) over () then I'm almost certain we wouldn't need to be using non-supported clustered index approaches to running total aggregates... though we wouldn't have had one of the coolest articles around on this approach, of course


Heh... thanks for that. As a side bar, there is a super fast way to guarantee either that the running total worked or get a notification that it didn't that Paul White and Tom Thompson came up with. That's a good thing because just before that, Wayne S. was the first and only person I've ever met that broke a previously good running example. I'm thinking I need to update the article (hopefully) one more time and then maybe retire.

Shifting gears, I wouldn't necessarily say that Oracle is ahead of the game for SQL standards. The last time I looked, Oracle had nothing with DATEDIFF, DATEADD, etc, etc and, IIRC, those are part of the SQL standards.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1004087
Posted Thursday, October 14, 2010 12:33 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 7:42 PM
Points: 176, Visits: 528
Here are my thoughts after going from many years SQL Server to an extended project in Oracle:

I certainly found a lot of things in Oracle quite 'alien' to me and was initially very resistant and cynical.(particularly having to use a third party tool to develop - TOAD which I think has a user interface like a car accident).

The poster who mentioned that Oracle has loads of baggage is really on the money. MS can now sit back and emulate all the good parts of Oracle without having to take on the baggage!

I'm impressed with Oracle packages as they almost seem like classes to me
-Variables which 'reflect' existing table meta data
-Custom data types
-Multiple 'methods' within the package all returning different types

So you can truly wrap up a large piece of logic in a package which has various methods which can be called.

The other thing that impresses me is the optimiser and the way it can decompose multiple levels of views. You can define many layers of views to contain your business logic and usually be happy that it will still perform. Back in SQL 2000 I tried doing this and it appeared to be effectively materialising the data at each level rather than doing any smart 'rewriting' - maybe things have changed by SQL 2008 though.


In summary, you'd be well served to jump the hurdle and get some experience to make an informed judgement about the two different platforms.

PS at a current client we indeed have what seems to be a political decision to move from Oracle to SQL Server.
Post #1004149
Posted Thursday, October 14, 2010 6:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258, Visits: 494
Jeff Moden (10/13/2010)
ta.bu.shi.da.yu (9/17/2010)
2. Oracle has implemented more of the SQL standard that Microsoft. Case in point: try doing a lag, lead, or top analytic function in SQL Server... you can't! You can only use rank, denserank, and row_number. If you were able to use lag(column) over () then I'm almost certain we wouldn't need to be using non-supported clustered index approaches to running total aggregates... though we wouldn't have had one of the coolest articles around on this approach, of course


Heh... thanks for that. As a side bar, there is a super fast way to guarantee either that the running total worked or get a notification that it didn't that Paul White and Tom Thompson came up with. That's a good thing because just before that, Wayne S. was the first and only person I've ever met that broke a previously good running example. I'm thinking I need to update the article (hopefully) one more time and then maybe retire.

Shifting gears, I wouldn't necessarily say that Oracle is ahead of the game for SQL standards. The last time I looked, Oracle had nothing with DATEDIFF, DATEADD, etc, etc and, IIRC, those are part of the SQL standards.


Really? OK, that surprises me... good pickup! As far as I'm aware, Oracle doesn't have a Connect like Microsoft does, so I guess there's no way of providing feedback!


Random Technical Stuff
Post #1004268
Posted Thursday, October 14, 2010 6:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 6,544, Visits: 8,759
If you look at these two posts, especially the signature, and that these are the only posts ever from this poster, they feel more like spam for their kitchen cabinets.

harrifolfenced (10/13/2010)
what are advantages of oracle over sql
harrifolfenced (10/13/2010)
thanks for above links i also solved my stored procedure code


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1004312
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse