开始
SET SERVEROUTPUT ON; DECLARE TYPE emp_record_type IS RECORD ( empno emp.empno%TYPE, empname emp.ename%TYPE); emp_record emp_record_type; BEGIN emp_record.empno:=10; emp_record.empname:='TEST'; dbms_output.put_line('empno: '||emp_record.empno ||' empname: ' || emp_record.empname); END; /
运行结果：
anonymous block completed empno: 10 empname: TEST
结束
使用python协程实现异步爬取网站。
开始--INDEX BY TableSET SERVEROUTPUT ON;DECLARE TYPE enm_tab_type IS TABLE OF emp.ename%TYPE INDEX BY BINARY_INTEGER; enm_table enm_tab_type;BEGIN enm_table(1):='ABCD'; IF enm_table.EXISTS(1) THEN dbms_output.put_line( enm_table(1)); ELSE dbms_output.put_line( 'not exists(1)...
开始--INDEX BY TableSET SERVEROUTPUT ON;DECLARE TYPE enm_tab_type IS TABLE OF emp%ROWTYPE INDEX BY BINARY_INTEGER; enm_table enm_tab_type;BEGIN SELECT * INTO enm_table(1) FROM emp WHERE empno=7900; SELECT * INTO enm_table(2) FROM emp WHERE empno=7902; END;/要注意的是：s...
开始DECLARE CURSOR emp_cursor IS SELECT empno, ename, dname FROM emp_cpy, dept WHERE emp_cpy.deptno=dept.deptno AND emp_cpy.deptno = 20 FOR UPDATE OF sal NOWAIT; emp_record emp_cursor%ROWTYPE;BEGIN LOOP IF NOT emp_cursor%ISOPEN THEN OPEN emp_cursor; END IF; FETCH emp_cu...
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG，图片不超过1.9M
