If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > SQL exclude query???

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Apr 2003
Location: Washington DC area
Posts: 1,708
SQL exclude query???

Hello,

I have data in a table and I need to exclude data if it meets a certain criteria. This need to produce a new table listing and be provided to a application. First, I need to:

SELECT * FROM ACTIVITY
WHERE
ACTIVITY_NM LIKE '%UNKNOWN'

And
__________________
Garry D
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,572
please be more vague to make answering more challenging.

We do not know what you start with.
We do not know what the actual results should be.
Other than that your problem statement is as clear as mud.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Apr 2003
Location: Washington DC area
Posts: 1,708
Cool SQL Exclude query????

That's the difference from a DBA and a Developer, Left coast and Right coast. I think not like solves the issue for me. My problem is this is a application driven by developers. Not the database. So, the data is all #$%%$*&*(T(*&^)$. No referencial intergrity. Were if it was database driven. I would not need to clean up data to produce back to a application that will continue to have bad data in the database tables.

Just a thought.

Sorry, need to attend the SAN

P.S.
Please if you know of anyone in this industry coast to coast and world wide. Please have them to look at this sites "job opportunites" and appy.

Thanks
G
__________________
Garry D
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,572
THANKS for the clarification.

NOT!
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Apr 2003
Location: Washington DC area
Posts: 1,708
Talking SQL Exclude query????

With all your post. You got to be a vet with alot of experience. So when thing like this come up. Who has time to remember the coding you did 20 years ago. Hell, That's how I got my start in the industry. Oh, yeah, we did have things like this this. You remember verion 5.0 of Oracle. THERE was no internet, Forum. hell. Email had just come along. The good old days.

When technology move faster than a Bug and Elmer fud.
__________________
Garry D
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Jun 2004
Posts: 733
One of the first rules I learnt when I started in IT was never to touch a keyboard if I'd been drinking...
__________________
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,657
Cool

Quote:
Originally Posted by garrydawkins View Post
... So, the data is all #$%%$*&*(T(*&^)$. No referencial intergrity. Were if it was database driven. I would not need to clean up data to produce back to a application that will continue to have bad data in the database tables.
If you try to fix (manipulate) the data in order to produce "acceptable" results, your customers (and developers) will get use to it and expect you to "fix" everytime the c.r.a.p. they enter (or allow to enter) the database.

If you cannot have the developers fix their own data, RUN as fast as you can.
Eventually they will blame YOU for the bad data.
__________________
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On