Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date ... Date ...Da

Re: Date ... Date ...Da

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 17 Apr 2004 15:06:24 GMT
Message-ID: <QJbgc.3043$hw5.3108@attbi_s53>

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:Taadnb1Sg6ikuxzdRVn-gg_at_comcast.com...
>
> "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
> news:DJudnd2DaMb8uRzdRVn-hQ_at_comcast.com...
> |
> | "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in
message
> | news:0l0gc.158117$JO3.95218_at_attbi_s04...
> | |
> | | "moon" <only_forme4_at_hotmail.com> wrote in message
> | | news:2afc1efd.0404160319.4b1feeef_at_posting.google.com...
> | | > Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote:
> | | > > Yes you should. The industry is currently already suffering more
> than
> | | > > enough from people like you.
> | | > > If you don't want that, find another job where you can earn money
by
> | | > > doing nothing.
> | | >
> | | > Forget Oracle for now! One of the books state this rule (may be for
> | | > you :) ):
> | | >
> | | > "An explicit type conversion (cast) is preferable to a doubtful
> | | > implicit type conversion."
> | | >
> | | > I don't know if you are feeling that (and I will be really sorry
:( ):
> | | >
> | | > Short + Double + Int
> | | >
> | | > is a doubtful expression.
> | | >
> | | > Peace : )
> | |
> | | Moon,
> | | I think you miss the point. Isn't the goal to make your logic work in
a
> | | scalable, reliable, useful fashion? Assuming that is your goal then
you
> | | need to understand that different environments, programming languages,
> | | RDBMSs, work differently. If you are going to rely on a default
> behavior
> | | then that default behavior may not work very well in a different
> context.
> | | In those cases you need to use whatever is recommended in that
> programing
> | | logic context. (eg explicitly do a conversion if that programing
> language
> | | calls for it.) It doesn't help you to write a program in Fortran and
> rely
> | | on behavior of Java. Since Fortran != Java.
> | |
> | | If I have mistated your goal then you just want to flame and in that
> case
> | | you go into the kill file.
> | | Jim
> | |
> | |
> |
> | always keep in mind that default behavior can change from version to
> version
> |
> | how much pre-9i SQL do you think broke when the GROUP BY clause stopped
> | ordering the rows?
> |
> | ;-{ mcs
> |
> |
>
> reference: MetaLink Note:224815.1

It was a stupid thing to rely on. It was never stated that group by without an order by would sort in a particular order. It was not a good behavior to rely on. Gosh the ANSI standard says that without the order by specification the order is indeterminate. Jim
>
>
Received on Sat Apr 17 2004 - 10:06:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US