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/07/01 07:29:34
![PL/SLQ select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什](/uploads/image/z/8926872-24-2.jpg?t=PL%2FSLQ+select+pluid%2Cplucode+from+tSkuPlu+where+plucode+in+%2850830%2C50840%29+%E8%BF%99%E4%B8%AA%E8%AF%AD%E5%8F%A5%E6%89%A7%E8%A1%8C%E6%8A%A5%E9%94%99+ora-01722%3Ainvalid+number+select+pluid%2Cplucode+from+tSkuPlu+where+plucode+%3D%E2%80%9850830%E2%80%99%E8%BF%99%E6%A0%B7%E5%B0%B1%E5%8F%AF%E4%BB%A5%2C%E4%BD%86%E6%98%AF%E6%88%91%E6%83%B3%E6%89%B9%E9%87%8F%E6%9F%A5%E8%A6%81%E6%80%8E%E4%B9%88%E5%86%99%7E%E5%89%8D%E9%9D%A2%E6%8A%A5%E9%94%99%E6%98%AF%E4%BB%80)
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’) 呢
PL/SLQ select pluid,plucode from tSkuPlu where plucode in (50830,50840) 这个语句执行报错 ora-01722:invalid number select pluid,plucode from tSkuPlu where plucode =‘50830’这样就可以,但是我想批量查要怎么写~前面报错是什
SELECT
slq语句 substring (firstname,1,3)+ substring (lastname,1,
slq语句 substring (firstname,1,3)+ substring (lastname,1,
PL是什么意思
n.(pl)
pl是什么意思
pl 是什么意思
pl是什么意思
PL是什么意思
pl是什么意思
什么是1PL、2PL、3PL、4PL?
piease.select
select()是什么?
select your
Select your
please select
Please select