1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| create table TAB1 (t_id number(1), t_vchr2 varchar2(3), t_chr char(3));
insert into tab1 (t_id, t_vchr2, t_chr) values (1, 'DF' , 'DF' );
insert into tab1 (t_id, t_vchr2, t_chr) values (2, 'DF ', 'DF ');
select 'DF-VC2' as tst, t_id, t_vchr2 || '*' as t_vchr2, t_chr || '*' as t_chr from tab1 where t_vchr2 = 'DF' union all
select 'DF-CHR' , t_id, t_vchr2 || '*' , t_chr || '*' from tab1 where t_chr = 'DF' union all
select 'DF -VC2' , t_id, t_vchr2 || '*' , t_chr || '*' from tab1 where t_vchr2 = 'DF ' union all
select 'DF -CHR' , t_id, t_vchr2 || '*' , t_chr || '*' from tab1 where t_chr = 'DF ';
TST T_ID T_VCHR2 T_CHR
------- ---- ------- -----
DF-VC2 1 DF* DF *
DF-CHR 1 DF* DF *
DF-CHR 2 DF * DF *
DF -VC2 2 DF * DF *
DF -CHR 1 DF* DF *
DF -CHR 2 DF * DF * |
Partager