[SQL ] PL SQL 變數問題
剛接觸PL/SQL幾個月,之前都是寫PHP,
想請問註解處有辦法組合成變數後印出值嗎?
DECLARE
CURSOR c1 IS (SELECT 'A' col_1, 'B' col_2, 'C' col_3
FROM dual)
BEGIN
FOR r1 IN c1 LOOP
FOR i IN 1..3 LOOP
DBMS_OUTPUT.PUT_LINE( /* r1.col_i */ );
END LOOP;
END LOOP;
END;
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.171.197.182
→
11/14 13:25, , 1F
11/14 13:25, 1F
→
11/14 16:59, , 2F
11/14 16:59, 2F
→
11/14 16:59, , 3F
11/14 16:59, 3F
→
11/14 17:04, , 4F
11/14 17:04, 4F
→
11/15 17:08, , 5F
11/15 17:08, 5F