oracle变量表类型declaretype my_emp is table of scott.emp%rowtypeindex by binary_integer;new_emp my_emp;v_num number:=0;cursor cur_emp is select empno,ename,job,sal from scott.emp;--1.cursor 是个什么东东?beginfor v_emp in cur_emp loop --2.v
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/08 13:22:38
![oracle变量表类型declaretype my_emp is table of scott.emp%rowtypeindex by binary_integer;new_emp my_emp;v_num number:=0;cursor cur_emp is select empno,ename,job,sal from scott.emp;--1.cursor 是个什么东东?beginfor v_emp in cur_emp loop --2.v](/uploads/image/z/15088167-63-7.jpg?t=oracle%E5%8F%98%E9%87%8F%E8%A1%A8%E7%B1%BB%E5%9E%8Bdeclaretype+my_emp+is+table+of+scott.emp%25rowtypeindex+by+binary_integer%3Bnew_emp+my_emp%3Bv_num+number%3A%3D0%3Bcursor+cur_emp+is+select+empno%2Cename%2Cjob%2Csal+from+scott.emp%3B--1.cursor+%E6%98%AF%E4%B8%AA%E4%BB%80%E4%B9%88%E4%B8%9C%E4%B8%9C%3Fbeginfor+v_emp+in+cur_emp+loop+--2.v)
xSn@~T 1@fI]ٻ@|PɩBTU4IRSR5/]-:^RS%[of\r+馍yhf ?ݯa.FNYuƈ֑gRWVd~62,v">L#%/ZJlT3̣gQ66}
&P_ThGx҉oZfLElJ]?S%ַ/#`!dԐIoUwHx