SEO

I have seen these Yukon features in Oracle for years...

- Jack

Sorry, here is the link -
http://www.sqlmag.com/articles/index...rticleid=40455

"Jack Wang" <nospam@nospam.com> wrote in message
news:Egxmb.22215$EO3.5744@clgrps13...
> I have seen these Yukon features in Oracle for years...
>
> - Jack
>
>
>

Don't forget that now M$ has implemented
them, it will be a "world first"...


--
Cheers
Nuno Souto
wizofoz2k@yahoo.com.au.nospam
"Jack Wang" <nospam@nospam.com> wrote in message news:QGzmb.22295$EO3.13048@clgrps13...
> Sorry, here is the link -
> http://www.sqlmag.com/articles/index...rticleid=40455
>
> "Jack Wang" <nospam@nospam.com> wrote in message
> news:Egxmb.22215$EO3.5744@clgrps13...
> > I have seen these Yukon features in Oracle for years...
> >
> > - Jack
> >
> >
> >
>
>

From that article ( Microsoft's Eric Brown goes inside SQL Server's next
release )
>> T-SQL is the best query language for relational databases and always will
be.

How &*^%$ing shamelessly arrogant.....




> Sorry, here is the link -
> http://www.sqlmag.com/articles/index...rticleid=40455

--
"Robert C" <rchin@panix.com> wrote in message
news:bnheb6$b0m$1@reader1.panix.com...
> From that article ( Microsoft's Eric Brown goes inside SQL Server's next
> release )
> >> T-SQL is the best query language for relational databases and always
will
> be.
>
> How &*^%$ing shamelessly arrogant.....
>

Arrogant? More like ignorant ...

T-SQL is a query language ?

>
>
>
> > Sorry, here is the link -
> > http://www.sqlmag.com/articles/index...rticleid=40455
>
>
>
>

The syntax of T-SQL is unlike any other I have seen, only looks good to
those people in Redmond. If you ask what turns me off the most about SQL
Server, T-SQL would be it.

"Robert C" <rchin@panix.com> wrote in message
news:bnheb6$b0m$1@reader1.panix.com...
> From that article ( Microsoft's Eric Brown goes inside SQL Server's next
> release )
> >> T-SQL is the best query language for relational databases and always
will
> be.
>
> How &*^%$ing shamelessly arrogant.....
>
>
>
>
> > Sorry, here is the link -
> > http://www.sqlmag.com/articles/index...rticleid=40455
>
>
>
>

Well some have analogies and some aren't there in Oracle (don't know about
10 haven't seen it).

For example what version of Oracle allows

multiple (> 2) programming languages in the database?
enhanced select TOP ....
seperate date and time datatypes?
try..catch in PL/SQL?
EM integrated with your dev tools?

if they have been there for years.

--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Jack Wang" <nospam@nospam.com> wrote in message
news:QGzmb.22295$EO3.13048@clgrps13...
> Sorry, here is the link -
> http://www.sqlmag.com/articles/index...rticleid=40455
>
> "Jack Wang" <nospam@nospam.com> wrote in message
> news:Egxmb.22215$EO3.5744@clgrps13...
> > I have seen these Yukon features in Oracle for years...
> >
> > - Jack
> >
> >
> >
>
>

T-SQl is a "quewy language" now?
I know it sounds childish, but:
BWAHAHAHAHA!


--
Cheers
Nuno Souto
wizofoz2k@yahoo.com.au.nospam
"Robert C" <rchin@panix.com> wrote in message news:bnheb6$b0m$1@reader1.panix.com...
> From that article ( Microsoft's Eric Brown goes inside SQL Server's next
> release )
> >> T-SQL is the best query language for relational databases and always will
> be.
>
> How &*^%$ing shamelessly arrogant.....
>
>
>
>
> > Sorry, here is the link -
> > http://www.sqlmag.com/articles/index...rticleid=40455
>
>
>
>

Comments in-line.

Niall Litchfield wrote:

>Well some have analogies and some aren't there in Oracle (don't know about
>10 haven't seen it).
>
>For example what version of Oracle allows
>
>multiple (> 2) programming languages in the database?
>
Is it a big deal whether it is "in" or "out"? Isn't the important
question whether the language
can be used in conjunction with the product?

If so then I submit that SQL, PL/SQL, SQLJ, Java, C, C++, Cobol,
Fortran, Perl, and
a plethora of scripting languages (PHP, KSH, etc.) is as close as I need
to be.

>enhanced select TOP ....
>
I'd need a more complete description to respond.

>seperate date and time datatypes?
>
Why? To what possible gain? Time bereft of date is almost always
meaningless.

>try..catch in PL/SQL?
>
Explain.

>EM integrated with your dev tools?
>
>if they have been there for years.
>
>
>
Now I'm completely confused by what you are asking. Unfortunately that
didn't stop me from responding as best I could. ;-)

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Most of your comments are along the lines of ... but that feature isn't any
help to me ... which is fair enough but Oracle having useless features for
years isn't really a winning argument to me. Specific comments embedded.

"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1067263636.748400@yasure...
> Comments in-line.
>
> Niall Litchfield wrote:
>
> >Well some have analogies and some aren't there in Oracle (don't know
about
> >10 haven't seen it).
> >
> >For example what version of Oracle allows
> >
> >multiple (> 2) programming languages in the database?
> >
> Is it a big deal whether it is "in" or "out"? Isn't the important
> question whether the language
> can be used in conjunction with the product?
>
> If so then I submit that SQL, PL/SQL, SQLJ, Java, C, C++, Cobol,
> Fortran, Perl, and
> a plethora of scripting languages (PHP, KSH, etc.) is as close as I need
> to be.

I tend to agree - this probably does't surprise you - but if there is a case
for having stored procedures written in java in the db, then probably the
ability to write stored procedures in C#,VB,C++,J# (probably the most likely
order that they would be used) would appear to be an improvement on the
Oracle offering.

>
> >enhanced select TOP ....
> >
> I'd need a more complete description to respond.

does Oracle offer select TOP .. at all? One of those easily worked around
limitations that probably irritate a fair number of people trying to write
db independent code - lets not go down the is this a good idea or not route.

> >seperate date and time datatypes?
> >
> Why? To what possible gain? Time bereft of date is almost always
> meaningless.

We have a report that we need to write on activity in working hours and out
of working hours, we query on just the time part of the field. Again
relatively easy but a nice to have feature

>
> >try..catch in PL/SQL?
> >
> Explain.

Create or replace longProcedure as
...
begin
try
query that might return no rows
catch NO_DATA_FOUND
.....
end try

do some stuff
try
query that might throw a user defined exception but not normally
NO_DATA_FOUND
catch UDE
....
end try

....
EXCEPTION
WHEN NO_DATA_FOUND
.... I have really had an error here.

end ;
/

in other words if you expect certain errors in certain parts of code then
deal with them there. Now personally i'd probably write that as
Create or replace longProcedure as
begin
call subProc1
call subProc2
EXCEPTION
end;

etc

> >
> >
> Now I'm completely confused by what you are asking. Unfortunately that
> didn't stop me from responding as best I could. ;-)

My only point was that the OP stated that the article listed as new a whole
bunch of features that Oracle had had 'for years' and yet when you got into
specific features rather than marketing waffle a fair number of them seemed
new both to mssql and to oracle. I have no problem arguing that oracle is a
technically superior product - though I have issues with its pricing and
marketing - but if we are going to do conparisons lets do them based on
facts and not broad generalisations. One might as well look at the marketing
for 10g and say 'ah but sqlserver has been easy to manage for years'.


--
Niall Litchfield
Oracle DBA
Audit Commission Uk