comparing comma separated values [message #653437] |
Tue, 05 July 2016 09:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sumedh7
Messages: 31 Registered: March 2007 Location: Pune,India
|
Member |
|
|
Hi All,
I have i table column with values like ('XYZ','ABC','OPQ','PQR')which is appearing from front end (check box values)
out of which i have few check box values which when selected it should be allowed, for other it shouldn't allow (display error message)
i have issue for third scenario that if 1 value is selected as per my list & other not in my list in this case it should display message
for ex list iam having is 'ABC' & 'PQR' and in check box selected values are 'ABC'&'XYZ'
for this i want to write sql query only, i tried regexp but not getting correct value please suggest on this;
Note values in column may be in any sequence
[Updated on: Tue, 05 July 2016 10:03] Report message to a moderator
|
|
|
|
Re: comparing comma separated values [message #653482 is a reply to message #653438] |
Thu, 07 July 2016 01:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Here's an example of how to convert your string into rows you could then use in checking process. See if it helps.
SQL> WITH test AS (SELECT 'XYZ,ABC,OPQ,PQR' col FROM DUAL)
2 SELECT REGEXP_SUBSTR (col,
3 '[^,]+',
4 1,
5 LEVEL)
6 result
7 FROM test
8 CONNECT BY REGEXP_SUBSTR (col,
9 '[^,]+',
10 1,
11 LEVEL)
12 IS NOT NULL;
RESULT
---------------
XYZ
ABC
OPQ
PQR
SQL>
|
|
|
|
|