CREATE TABLE TEST_XX
(
  ID      NUMBER,
  IDX    NUMBER,
  IDY        NUMBER);
/
INSERT INTO TEST_XX
 VALUES (1,2,3);
 /
  
DECLARE
 TEST_XX_ROW TEST_XX%ROWTYPE;
BEGIN
 SELECT * INTO TEST_XX_ROW
  FROM TEST_XX
  WHERE ROWNUM = 1;
END;  

CREATE TABLE TEST_XX
(
  ID      NUMBER,
  IDX    NUMBER,
  IDY        NUMBER);
/
INSERT INTO TEST_XX
 VALUES (1,2,3);
 /
INSERT INTO TEST_XX
 VALUES (4,5,6);
 /
  
DECLARE
 TYPE TYPE_TEST_XX_TABLE IS TABLE OF TEST_XX%ROWTYPE;
 TEST_XX_TABLE TYPE_TEST_XX_TABLE ;
BEGIN
 SELECT * BULK COLLECT INTO TEST_XX_TABLE
  FROM TEST_XX;
END;