Hello,
Does exists any easy way to return rows from select statement which is in BEGIN END block
e.g
BEGIN
SELECT * FROM TABLE;
END;
/
Also does is possible to use variable between blocks or out of block? I mean
DECLARE
vResult NUMBER;
BEGIN
SELECT COUNT(*) INTO vResult FROM TABLE;
END;
/
SELECT vResult FROM dual;
?
M.