Last active
April 7, 2020 14:34
-
-
Save aykononov/0482d7240ce842bbf4137bc6ccc10e63 to your computer and use it in GitHub Desktop.
BULK COLLECT
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Имеется декларация типа: | |
CREATE OR REPLACE TYPE TNUM as table of number; | |
Необходимо написать реализацию функции, возвращающую в качестве результата заполненный массив | |
имеющий тип TNUM с значениями от 1..1000 | |
*/ | |
CREATE OR REPLACE NONEDITIONABLE FUNCTION fnc_get_tnum | |
RETURN tnum | |
IS | |
v_mas_tnum tnum; | |
BEGIN | |
SELECT LEVEL | |
BULK COLLECT INTO v_mas_tnum | |
FROM dual CONNECT BY LEVEL <= 1000; | |
RETURN v_mas_tnum; | |
END fnc_get_tnum; |
Author
aykononov
commented
Nov 11, 2019
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment