RE: Something I'm missing in minus set operation...oops

From: "Stephens, Chris" <ChrisStephens@xxxxxxx>
To: <mwf@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 26 Oct 2004 08:00:19 -0400

Yep...one more sip of coffee.

I neglected to take out a literal table name from the bottom piece.=20

Sorry about this. ...i promise not to post anything before 8:30am
anymore! :)=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stephens, Chris
Sent: Tuesday, October 26, 2004 7:55 AM
To: mwf@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Something I'm missing in minus set operation...

No...i actually didn't do a straight copy and paste...i have 'where
owner=3D3D'OWNER';'

Sorry about that.=3D20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark W. Farnham
Sent: Tuesday, October 26, 2004 7:52 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Something I'm missing in minus set operation...

I'm guessing you probably want owners and table_names in there
someplace.....

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephens, Chris
Sent: Tuesday, October 26, 2004 7:46 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Something I'm missing in minus set operation...


We have a table here used by a web app to determine columns for
particular tables.  The table is out of sync with the actual columns in
the tables.  To determine which columns should be removed from the table
I wrote the following:

Select distinct(trim(col_name))
>From owner.col_dim
Minus
Select distinct(trim(column_name))
>From sys.all_tab_columns;

...but that is yielding the wrong results.  What am I missing?  The
datatypes are the same.  ...i don't even think I should need the trim in
there but that too yields wrong results.

? ....it is very early here so I have somewhat of an excuse.

Thanks
chris=3D3D20
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

RE: Something I'm missing in minus set operation...oops

Other related posts: