存储过程DIY3----游标中可以使用子查询：

游标中可以使用子查询：

（1）WHERE 子句中  

  DELCARE

v_name tdz.vxm%TYPE;

 v_class tdz.vbj%TYPE;

------------------------------------------------------------------------------------------------------------------------------

CURSOR mycursor IS

SELECT vxm.obj from tdz where vbj IN  (SELECT vbj from tdjsz where vid='1');//

-------------------------------------------------------------------------------------------------------------------------

（2）FROM 子句中

select t1.vjsztm,  t1.vxm,   t1.vbj ,   t3.classcount

from tdz t1,  tbjsz t2,     (select   vid,  (count(*) classcount     from tbjsz    GROUP BY   vid  )   t3

where t1.vbj=t2.vbj AND t2.vid=t3.vid  AND  t3.classcount>9;