将select查询的结果存入到定义的变量中
declareV_tno sutdent.stuno%TYPE; --创建变量,存储学生学号V_tnsex varchar2(6); --创建变量,存储学生性别V_tname varchar2(30); --创建变量,存储学生姓名begin/**临时表*/for cur_ss in (select t.* from student t) loopV_tno := null;V_tname := null;/**给V_tno赋值。即 V_tno = max(stuno)+1 */select max(stuno)+1 into V_tno from student ;/**也可以将多个列存储多个变量中,但必须有一条记录,否则抛出异常(如果没有记录抛出NO_DATA_FOUND)*/select stusex,stuname into V_tnsex, V_tname from student where stuname is not null;--V_tname := LPAD(ldgx.SEQ_CEZ008.NEXTVAL, 16, '0');......end loop;end