DECLARE
TYPE courselist IS TABLE OF VARCHAR2(10) ;
courses courselist;
BEGIN
courses := courselist('Biol 4412', 'Psyc 3112', 'Anth 3001');
courses.delete(3); -- delete element 3
/* PL/SQL keeps a placeholder for element 3. So, the
next statement appends element 4, not element 3. */
courses.extend; -- append one null element
/* Now element 4 exists, so the next statement does
not raise SUBSCRIPT_BEYOND_COUNT. */
courses(4) := 'Engl 2005';
dbms_output.put_line(courses(1));
dbms_output.put_line(courses(2));
--dbms_output.put_line(courses(3));
dbms_output.put_line(courses(4));
END;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25684327/viewspace-692852/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25684327/viewspace-692852/