OraFAQ Forum: SQL & PL/SQL » Oracle SQL a=b and b=a

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle SQL a=b and b=a (Oracle 12C)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle SQL a=b and b=a [message #685151]

Fri, 29 October 2021 06:24

rahul1982
Messages: 53
Registered: November 2011
Location: Pune

Member

Hello team,

Below are my table values, there are 2 columns. Below example has ColA value present in ColB as well as ColB in ColA hence want to delete one of the record.

ColA			ColB	
00300000003TuDlAAK	003000000068VWTAA2
003000000068VWTAA2	00300000003TuDlAAK

Any clues or help would be appreciated.

Thanks!

[Updated on: Fri, 29 October 2021 06:32]

Report message to a moderator

Re: Oracle SQL a=b and b=a [message #685152 is a reply to message #685151]

Fri, 29 October 2021 08:08

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Same thing as in the following topic: SQL Query for duplicates.

Report message to a moderator

Re: Oracle SQL a=b and b=a [message #685153 is a reply to message #685151]

Fri, 29 October 2021 09:10

rahul1982
Messages: 53
Registered: November 2011
Location: Pune

Member

Thanks, its working as expected.

Report message to a moderator

Re: Oracle SQL a=b and b=a [message #685155 is a reply to message #685153]

Fri, 29 October 2021 14:25

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

rahul1982 wrote on Fri, 29 October 2021 09:10

Thanks, its working as expected.

But if the example you gave constitutes a 'duplicate record' - the business meaning of ColA is the same as the business meaning of ColB, then I'd have some serious questions about the data design.

Report message to a moderator

Previous Topic:	Long query with WITH not responding
Next Topic:	Data Dictionary for Collection Bind variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 28 03:24:19 CDT 2023