Dear Friends,
I need to get the data from T2 using T1 column data. Basically T1 is holding code and description for the codes are in T2.
In table T1 data is stored as below:
Description for above code is in table T2 data stored as below:
Now I have written a code to retrieve the description using T1 table data:
select upper('('''||replace(data1,',',''',''')||''')') from t1;
Result:
('2BA','2R','BAL','HI')
Using IN operator: When I run below code I am not able to get any data.
1. Is there any mistake in my code?
2. Is this the correct way to use the code like below ?
3. Do we have any other idea to get the correct data?
select data1_desc from t2 WHERE upper(data1_desc) IN (
select upper('('''||replace(data1,',',''',''')||''')') from t1);
Result : NULL
Codes to create the table and data:
create table t1 (data1 varchar2(200));
create table t2 (data1 varchar2(200),data1_desc varchar2(2000));
insert into t1 values ('2BA,2R,BAL,HI');
insert into t2 values ('2BA','2 Basket');
insert into t2 values ('2R','2 Room');
insert into t2 values ('BAL','Ball Room');
insert into t2 values ('HI','High Floor with view');
select * from t1;
select * from t2;
select upper('('''||replace(data1,',',''',''')||''')') from t1;
select data1_desc from t2 WHERE upper(data1) IN (
select ('('''||replace(data1,',',''',''')||''')') from t1);
Regards,