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


Learning Oracle


Learning Oracle

Author
Message
ta.bu.shi.da.yu
ta.bu.shi.da.yu
SSC-Addicted
SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)

Group: General Forum Members
Points: 409 Visits: 494
WayneS (10/14/2010)
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


LOL - I reported this already. But you know what, in this case it produced some pretty decent discussion.

How about that. Even the spam on this site is helpful.

Random Technical Stuff
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12278 Visits: 10651
PaulB-TheOneAndOnly (10/13/2010)
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 ;-)

You're correct, but at least SQL Server will prune the dead branches from it's family tree from time to time. Microsoft has always been much more adaptable than it's competitors, even if a large percentage of their customers were drug along kicking and screaming, but in the end they've proven to be wise risk takers.


"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."
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12278 Visits: 10651
nick.mcdermaid (10/14/2010)
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!
...
...
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.

I use the SQL Developer tool provided by Oracle, and for day to day development, it's good enough, however TOAD obviously has more functionality and better DBA and performace monitoring features. I developed entirely in SQL Server for several years and for the past two years or so have been splitting my time between several smaller sized SQL Server projects and a large Oracle 11g data warehouse. When it comes to just writing SQL queries, the two platforms are very similar, and a developer new to Oracle may at first be overwhelmed by all the thick books and tend to overestimate the number differences. However, it's also easy to underestimate how frustrating those minor differences can be when you find yourself in a jam. I can recall early on how I would be sitting with my laptop in a project status meeting, answering questions about the data model and performing ad-hoc query requests. My screen would be displayed on a projector, and I'd be fumbling with the syntax of a fairly complicated Oracle SQL statement while management and business analysts patiently sat by watching. Fortunately those awkward first few months are behind me, and I'm now about equally proficient with both SQL Server and Oracle, at least in terms of SQL. Now in terms of PL/SQL vs T-SQL, database administration and architecture, there are more significant differences between SQL Server and Oracle and a more significant learning curve.


"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."
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5359 Visits: 4639
nick.mcdermaid (10/14/2010)
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


...and you are absolutely correct.

Are you old enough to remember Ada - the programming language? packages come from there.

_____________________________________
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.
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39305 Visits: 38529
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
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


...and you are absolutely correct.

Are you old enough to remember Ada - the programming language? packages come from there.



I remember ADA, took a couple of courses that used it in college? I may still have the books some where at home.

Does the language still live or has it gone the way of the dinosaur?

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)
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5359 Visits: 4639
Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
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


...and you are absolutely correct.

Are you old enough to remember Ada - the programming language? packages come from there.



I remember ADA, took a couple of courses that used it in college? I may still have the books some where at home.

Does the language still live or has it gone the way of the dinosaur?

That's a very good question indeed :-D
Just checked Monter and guess what? There are job opennings mentioning Ada skills/experience as requisites - go figure :-)

_____________________________________
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.
WayneS
WayneS
SSCrazy Eights
SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)

Group: General Forum Members
Points: 9835 Visits: 10569
Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
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


...and you are absolutely correct.

Are you old enough to remember Ada - the programming language? packages come from there.



I remember ADA, took a couple of courses that used it in college? I may still have the books some where at home.

Does the language still live or has it gone the way of the dinosaur?

You guys are aging yourselves... I'm kinda old, and the only thing I remember about this is hearing about it! w00t

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
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

Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39305 Visits: 38529
WayneS (10/16/2010)
Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
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


...and you are absolutely correct.

Are you old enough to remember Ada - the programming language? packages come from there.



I remember ADA, took a couple of courses that used it in college? I may still have the books some where at home.

Does the language still live or has it gone the way of the dinosaur?

You guys are aging yourselves... I'm kinda old, and the only thing I remember about this is hearing about it! w00t


Okay, how old do you think I am?

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
Old Hand
Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)

Group: General Forum Members
Points: 390 Visits: 778
I've read about ADA but no I've never used it. C++ was the language of choice when I was at uni (engineering not computer science though)

You know its very interesting that:

1. Packages are based on a proper programming language - I knew there was something to it!
2. That it based on such a 'fundamental' (polite word for old!!!!) programming language. Again it highlights that Oracle has old roots. Which can be a good thing and a bad thing!


N
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5359 Visits: 4639
WayneS (10/16/2010)
Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
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


...and you are absolutely correct.

Are you old enough to remember Ada - the programming language? packages come from there.



I remember ADA, took a couple of courses that used it in college? I may still have the books some where at home.

Does the language still live or has it gone the way of the dinosaur?

You guys are aging yourselves... I'm kinda old, and the only thing I remember about this is hearing about it! w00t


Nah... you are not "old" Wayne, I'm sure you are an "experienced" professional ;-)

In my case I'm "experienced" enough to still remember Ada but not "experienced" enough to have already forgotten all about it :-D

_____________________________________
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.
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