By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (value) AS
SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= 3 ORDER BY DBMS_RANDOM.VALUE();
3 rows affected
SELECT * FROM table_name;
| VALUE |
|---|
| 2 |
| 3 |
| 1 |
DECLARE
var1 VARCHAR(20);
var2 VARCHAR(20);
BEGIN
WITH TABLE1 AS (SELECT ROWNUM RN, t.* FROM table_name t)
,A1 AS (SELECT TO_CHAR(VALUE) INTO var1 FROM TABLE1 WHERE RN = 1)
,A2 AS (SELECT TO_CHAR(VALUE) INTO var2 FROM TABLE1 WHERE RN = 2)
SELECT
COL1 AS var1,
COL2 AS var2
FROM TABLE2;
END;
/
ORA-06550: line 6, column 31:
PL/SQL: ORA-01744: inappropriate INTO
ORA-06550: line 5, column 3:
PL/SQL: SQL Statement ignored
DECLARE
var1 VARCHAR(20);
var2 VARCHAR(20);
BEGIN
SELECT TO_CHAR(VALUE)
INTO var1
FROM table_name
OFFSET 0 ROWS FETCH NEXT 1 ROW ONLY;
SELECT TO_CHAR(VALUE)
INTO var2
FROM table_name
OFFSET 1 ROWS FETCH NEXT 1 ROW ONLY;
DBMS_OUTPUT.PUT_LINE(var1);
DBMS_OUTPUT.PUT_LINE(var2);
END;
/
1 rows affected
dbms_output:
2
3