Home » SQL & PL/SQL » SQL & PL/SQL » delete duplicate (10g 10.1.0.2.0, XP)
delete duplicate [message #397368] Fri, 10 April 2009 06:43 Go to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
I want to DELETE all records where month name (M) is not in upper case. How can I?


please guide me.

SQL> ;
  1  select member_id,m,y
  2  from net
  3  where member_id=2005100
  4* and y=2008
SQL> /

MEMBER_ M            Y
------- --- ----------
2005100 APR       2008
2005100 AUG       2008
2005100 FEB       2008
2005100 Feb       2008
2005100 JAN       2008
2005100 JUL       2008
2005100 JUN       2008
2005100 MAR       2008
2005100 MAY       2008
2005100 NOV       2008
2005100 Nov       2008
2005100 OCT       2008
2005100 SEP       2008
2005100 feb       2008
2005100 sep       2008

15 rows selected.


Riaz
Re: delete duplicate [message #397369 is a reply to message #397368] Fri, 10 April 2009 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you said it:

month != upper(month)

Regards
Michel

[Updated on: Fri, 10 April 2009 06:46]

Report message to a moderator

Re: delete duplicate [message #397372 is a reply to message #397368] Fri, 10 April 2009 07:01 Go to previous message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Thank you.

Riaz
Previous Topic: Help with cursor and trigger
Next Topic: Percentage of index rebuild
Goto Forum:
  


Current Time: Wed Dec 07 14:56:08 CST 2016

Total time taken to generate the page: 0.12700 seconds