📄 parameterized.sql
字号:
REM Parameterized.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the declaration of a parameterized cursor.
DECLARE
CURSOR c_Classes(p_Department classes.department%TYPE,
p_Course classes.course%TYPE) IS
SELECT *
FROM classes
WHERE department = p_Department
AND course = p_Course;
BEGIN
OPEN c_Classes('HIS', 101);
END;
/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -