-
Notifications
You must be signed in to change notification settings - Fork 14
Expand file tree
/
Copy path11g_frc_simple_demo.sql
More file actions
35 lines (31 loc) · 993 Bytes
/
Copy path11g_frc_simple_demo.sql
File metadata and controls
35 lines (31 loc) · 993 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
CREATE OR REPLACE FUNCTION betwnstr (
string_in IN varchar2, start_in IN integer, end_in IN integer)
RETURN varchar2 RESULT_CACHE
IS
BEGIN
DBMS_OUTPUT.put_line (
'betwnstr for ' || string_in || '-' || start_in || '-' || end_in);
RETURN (SUBSTR (string_in, start_in, end_in - start_in + 1));
END;
/
DECLARE
l_string employees.last_name%TYPE;
BEGIN
FOR rec IN (SELECT *
FROM employees
WHERE ROWNUM < 11)
LOOP
l_string :=
CASE MOD (rec.employee_id, 2)
WHEN 0 THEN betwnstr (rec.last_name, 1, 5)
ELSE betwnstr ('FEUERSTEIN', 1, 5)
END;
END LOOP;
END;
/
/*======================================================================
| Supplement to the fifth edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2009 O'Reilly Media, Inc.
| To submit corrections or find more code samples visit
| http://oreilly.com/catalog/9780596514464/
*/