摘要：
The PL/SQL Text Book《Oracle PL/SQL Programming》Anchored DeclarationsWhen you anchor a datatype,you tell PL/SQL to set the datatype of your variable based on the datatype of an already defined data structure-another PL/SQL variable,a predefined TYPE or SUBTYPE,a database table,or a specific column in 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to do the following:Describe PL/SQL collections and recordsCreate user-defined PL/SQL recordsCreate a PL/SQL record with the %ROWTYPE attributeCreate associative arraysOracle数据库中，复合数据类型包含:集合(collections)、记录(records)Oracle数据库中，集合的类型:(关联数组、嵌套表、 阅读全文
摘要：
1、FOR循环下，不需要显示关闭游标DECLARE CURSOR c_emp_cursor ( deptno NUMBER ) IS SELECT employee_id,last_name FROM employees WHERE department_id = deptno; r c_emp_cursor%ROWTYPE;BEGIN FOR i IN c_emp_cursor(10) LOOP DBMS_... 阅读全文
摘要：
Cursor For LoopsSyntax:FOR record_name IN cursor_name LOOP statement1; statement2; ... END LOOP;The cursor FOR loop is a shortcut to process explict cursors.Implict open,fetch,exit and close cursor.The record isimplicit declared.Example:DECLARE CURSOR c_emp_curs... 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to do the following:Distinguish between implict and explicit cursorsDiscuss the reasons for using explicti cursorsDeclare and control explicit cursorsUse simple loops and cursor FOR loops to fetch dataDeclare and use cursors with parametersLo 阅读全文