Course table
COURSE_ID | NAME | PRICE |
---|---|---|
1 | SQL 1 | 10 |
2 | SQL 2 | 50 |
3 | HTML5 | 10 |
Varrays (variable-size arrays)
DECLARE TYPE name IS VARRAY(250) OF VARCHAR2(25); course_name name; BEGIN course_name := name('SQL 1', 'SQL 2', 'HTML5'); FOR i IN 1 .. course_name.COUNT LOOP FOR x IN (SELECT * FROM course WHERE name=course_name(i)) LOOP dbms_output.put_line('ID: '||x.course_id||' - Name: '||x.name); END LOOP; END LOOP; END; /
Output
ID: 1 – Name: SQL 1 |
ID: 2 – Name: SQL 2 |
ID: 3 – Name: HTML5 |