If you take of the where clause, you get the same result. I don't think
this answers the question.
SQLWKS> select 'IT DOES' from dual
2>
3>
'ITDOES
IT DOES
1 row selected.
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, May 22, 2002 10:38 AM
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 <ORACLE-L_at_fatcity.com>
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 <wisernet100_at_yahoo.com> 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 <jack_silvey_at_yahoo.com> 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 <wisernet100_at_yahoo.com>
> 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
> > >
> > > --- Jared.Still_at_radisys.com wrote:
> > > > Yup, $60, and worth every penny.
> > > >
> > > > It may be 4 years old, but the information is
> > > still pertinent.
> > > >
> > > > Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Joe Testa <jtesta_at_dmc-it.com>
> > > > Sent by: root_at_fatcity.com
> > > > 05/20/2002 05:53 PM
> > > > Please respond to ORACLE-L
> > > >
> > > >
> > > > To: Multiple recipients of list
> > > ORACLE-L
> > > > <ORACLE-L_at_fatcity.com>
> > > > cc:
> > > > Subject: Re: Data Warehouse
> > > experts, a simple question
> > > > for you
> > > >
> > > >
> > > > looks like published aug of 98 for that book?,
> > > like $60?
> > > >
> > > > joe
> > > >
> > > >
> > > > Jared.Still_at_radisys.com 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 <jtesta_at_dmc-it.com>
> > > > >Sent by: root_at_fatcity.com
> > > > >05/20/2002 04:08 PM
> > > > >Please respond to ORACLE-L
> > > > >
> > > > >
> > > > > To: Multiple recipients of list
> > > ORACLE-L
> > > > <ORACLE-L_at_fatcity.com>
> > > > > 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: jtesta_at_dmc-it.com
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: jack_silvey_at_yahoo.com
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: ListGuru_at_fatcity.com (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: tday6_at_csc.com
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: ListGuru_at_fatcity.com (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: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us
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: ListGuru_at_fatcity.com (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).
Received on Wed May 22 2002 - 15:03:42 CDT
