Try running:
select 'IT DOES' from dual where 2 = '02';
I guess that SQLPlus is doing an implicit data conversion.
Paula_Stankus
@doh.state.fl To: Multiple recipients of list ORACLE-L
.us <[EMAIL PROTECTED]>
Sent by: root cc:
Subject: RE: Data Warehouse experts, a
simple
question for you
05/21/2002
08:28 PM
Please
respond to
ORACLE-L
Okay you guys are silly.� I have probably a stupid basic question to ask.
How important is it to store data (let's say state codes, county codes with
leading zeroes as character versus numeric).� What is the standard out
there?� Does '02' mean the same thing as 2 for state code if you are
consistent throughout your warehouse or do we need to consider other
datasets out there that might be linked maybe sometime in the future?� Can
I leave it as is numeric and create materialized views with it padded or
should I bite the bullet and reload into char/varchar2 datatypes?
-----Original Message-----
Sent: Tuesday, May 21, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Yeah, that's a common misconception. You actually have
to prop the book on your forehead since English flows
to the left and downwards. I have heard that Chinese
flows from right to left and upwards or something
though - you might consider taking it up as a new
language if you are set on the underpillow method of
knowledge transfer.
/jack
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> gee, and here I thought all I had to do was put the
> book under my
> pillow and let the words seep in through osmosis :)
>
>
> --- Jack Silvey <[EMAIL PROTECTED]> wrote:
> > I find that if I wrap my books in Saran Wrap, I
> can
> > read in the shower. And if you prop the book up on
> > your shoulder, you can read it backwards in the
> > rearview mirror during drive time. Also, if you
> learn
> > to read in your sleep, you can get LOADS of stuff
> > done.
> >
> > ;)
> >
> > hth,
> > > > /jack silvey
> >
> >
> > --- Rachel Carmichael <[EMAIL PROTECTED]>
> wrote:
> > > it's cheaper on bookpool :)
> > >
> > > especially when Borders is out of stock
> > >
> > > you guys are killing my credit card!� I went out
> and
> > > bought Inmon's
> > > Building the Data Warehouse, BOTH Kimball books
> and
> > > and considering the
> > > Webhouse one as well.... geez, when do I have
> time
> > > to READ this stuff?
> > >
> > > Rachel
> > >
> > > --- [EMAIL PROTECTED] wrote:
> > > > Yup, $60, and worth every penny.
> > > >
> > > > It may be 4 years old, but the information is
> > > still pertinent.
> > > >
> > > > Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Joe Testa <[EMAIL PROTECTED]>
> > > > Sent by: [EMAIL PROTECTED]
> > > > 05/20/2002 05:53 PM
> > > > Please respond to ORACLE-L
> > > >
> > > >
> > > >�������� To:���� Multiple recipients of list
> > > ORACLE-L
> > > > <[EMAIL PROTECTED]>
> > > >�������� cc:
> > > >�������� Subject:������� Re: Data Warehouse
> > > experts, a simple question
> > > > for you
> > > >
> > > >
> > > > looks like published aug of 98 for that book?,
> > > like $60?
> > > >
> > > > joe
> > > >
> > > >
> > > > [EMAIL PROTECTED] wrote:
> > > >
> > > > >Joe,
> > > > >
> > > > >Add a generated PK to the time dimension.
> The PK
> > > is stored
> > > > >as an FK in the fact table.
> > > > >
> > > > >That way you can select from the time
> dimension
> > > by year, day, qtr,
> > > > >whatever,
> > > > >and easily pick out the correct fact table
> rows.
> > > > >
> > > > >"The Data Warehouse Lifecycle Toolkit"
> includes a
> > > spreadsheet to
> > > > generate
> > > > >the DDL/DML for a very robust time dimension.
>� I
> > > think it has about
> > > > 20
> > > > >columns.
> > > > >
> > > > >Very good book, can't recommend it enough.
> > > > >
> > > > >Jared
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >Joe Testa <[EMAIL PROTECTED]>
> > > > >Sent by: [EMAIL PROTECTED]
> > > > >05/20/2002 04:08 PM
> > > > >Please respond to ORACLE-L
> > > > >
> > > > >
> > > > >������� To:���� Multiple recipients of list
> > > ORACLE-L
> > > > <[EMAIL PROTECTED]>
> > > > >������� cc:
> > > > >������� Subject:������� Data Warehouse
> experts, a
> > > simple question
> > > > for you
> > > > >
> > > > >
> > > > >Ok i'm messing with dimensions.
> > > > >
> > > > >dm_time to be exact:
> > > > >
> > > > >create table dm_time
> > > > >( calendar_date date not null,
> > > > >� calendar_month number(2) not null,
> > > > >� calendar_qtr number(1) not null,
> > > > >� calendar_year number(4) not null);
> > > > >
> > > > >insert into dm_time
> > > values(to_date('20020101','YYYYMMDD'),
> > > > 1,1,2002);
> > > > >insert into dm_time
> > > values(to_date('20030101','YYYYMMDD'),
> > > > 1,1,2003);
> > > > >
> > > > > 2 rows nice and simple
> > > > >
> > > > > trying to validate the dimension comes up
> with
> > > an error, my guess
> > > > is
> > > > >because of the design of the table
> > > > >
> > > > > where basically calendar_date is child of
> > > > >���� calendar_month is child of calendar_qtr
> is
> > > child of
> > > > calendar_year,
> > > > >wont validate.
> > > > >
> > > > >-� the question i have is this, should month
> > > really be like 2002-01
> > > > with
> > > > >the year included, likewise with qtr, then it
> > > > >will validate ok.
> > > > >
> > > > >Was the design of dm_time just dont wrong or
> am i
> > > missing something
> > > > here.
> > > > >
> > > > >thanks, joe
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: Joe Testa
> > > >�� INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services��� -- (858) 538-5051
>
> > > FAX: (858) 538-5051
> > > > San Diego, California������� -- Public
> Internet
> > > access / Mailing
> > > > Lists
> > > >
> > >
> >
>
--------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list,
> send an
> > > E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling
> of
> > > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > > removed from).� You may
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
� INET: [EMAIL PROTECTED]
Fat City Network Services��� -- (858) 538-5051� FAX: (858) 538-5051
San Diego, California������� -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).� You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
