Hi
I have the below tables.
table group ( group_name clob)
table users ( user_id varchar2(100),group_name varchar2(100))
The group_name in table group is enclosed and comma separated long list object e.g 'g1','g2,'g3,'g4','g5'.....'g500'
I am writing the below pl/sql block to select the user_id's associated with the group names -I am unable to compare the varchar and clob columns. can we use clob column for comparision.
declare
user_csv clob;
for cursor1 in ( select group_name from group)
loop
select user_id into user_csv from users where group_name in ( cursor1.group_name);
PL/SQL: ORA-00932: inconsistent datatypes: expected - got CLOB
I need to get the user_id's in LIST_AGG format. Any help will be much appreciated .