PL/SLQ select pluid,plucode from tSkuPlu where plucode in (5
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/17 12:14:50
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 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’) 呢
试下select pluid,plucode from tSkuPlu where plucode in (‘50830’,‘50840’) 呢
PL/SLQ select pluid,plucode from tSkuPlu where plucode in (5
select * from teacher where s_id in(select s_id from student
select * from order where clientNo in (select distinct(clien
SELECT student_id FROM tuition where student_id in ( SELECT
select * from user_info where user_name in (select user_name
select ** from A where A.id in (select id from B where ****)
mysql select * from lsdl_user where id in (1,2,3,4,5)中in()最多
select id,name from student where id in ( select id from sco
delete from A where a_id in (select id from B where b_id in
英语翻译select top 4 * from shop_books where anclassid = (select
oracle 子查询:select *,(select account from t_ps_member m where
select * into b from a where 11