Try select 'IT DOES' from dual where 0=1;
It doesn't. Ruth Gramolini To: Multiple recipients of list ORACLE-L <rgramolini <[EMAIL PROTECTED]> @tax.state.vt cc: .us> Subject: Re: Data Warehouse experts, a simple Sent by: root question for you 05/22/2002 04:03 PM Please respond to ORACLE-L 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" <[EMAIL PROTECTED]> 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 <[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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).