PL/SLQ select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/04 07:13:41
PL/SLQ select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什

PL/SLQ select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什
PL/SLQ
select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number
select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什么原因

PL/SLQ select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什
plucode是字符类型,不能用整型的去查
试下select pluid,plucode from tSkuPlu where plucode in (‘50830’,‘50840’) 呢