Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date ... Date ...Da
"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 Received on Sat Apr 17 2004 - 07:42:11 CDT