question

sharmazkul avatar image
sharmazkul asked

How do I use a column separated filed within in clause

How do I use a column separated filed within in clause Table 1 (id,requestedColor) Data 1 Red,Green 2 Blue, 3 Yellow,Red The column RequestColor in table 1 has comma separated values table 2 (colorname) Data Red Pink Green I need to find all colors from table 2 for a given requestedColumn (from table 1). Please help.
sqloracleoracle-sql-developer
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.