OraFAQ Forum: SQL & PL/SQL » How to break column values

Home » SQL & PL/SQL » SQL & PL/SQL » How to break column values

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

How to break column values [message #246145]

Wed, 20 June 2007 01:57

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

Report message to a moderator

Re: How to break column values [message #246163 is a reply to message #246145]

Wed, 20 June 2007 02:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator