Home » SQL & PL/SQL » SQL & PL/SQL » How to break column values
How to break column values [message #246145] Wed, 20 June 2007 01:57 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

Here below is my scenario. The table A has column with comma seperated values like

Table A

col1 col2
1 A,B,C,D
2 X,Y,Z
3 P,Q


I have to compare col2 comma seperated values A with other column value in table B same with B, C and D

Any help really appreciated
Re: How to break column values [message #246163 is a reply to message #246145] Wed, 20 June 2007 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean compare? equal? include? intersect not null?

Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS.
Please always post your Oracle version (4 decimals).


Regards
Michel
Re: How to break column values [message #246174 is a reply to message #246163] Wed, 20 June 2007 03:30 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
Its equal
Re: How to break column values [message #246177 is a reply to message #246174] Wed, 20 June 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Equal with same order or different orders allowed?

Regards
Michel
Re: How to break column values [message #246184 is a reply to message #246177] Wed, 20 June 2007 04:05 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
same order
Re: How to break column values [message #246193 is a reply to message #246184] Wed, 20 June 2007 04:32 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So why not "="?

Regards
Michel
Previous Topic: TIMESTAMP Conversion
Next Topic: Where clause in SQL MERGE UPDATE statement
Goto Forum:
  


Current Time: Sun Dec 11 04:15:26 CST 2016

Total time taken to generate the page: 0.10824 seconds