在Oracle中，可以使用以下幾種方式來獲取行號：
SELECT ROWNUM, column1, column2
FROM table_name;
SELECT ROW_NUMBER() OVER (ORDER BY column1) AS row_num, column1, column2
FROM table_name;
DECLARE
cursor_name SYS_REFCURSOR;
row_num NUMBER := 1;
column1 table_name.column1%TYPE;
column2 table_name.column2%TYPE;
BEGIN
OPEN cursor_name FOR
SELECT column1, column2
FROM table_name;
LOOP
FETCH cursor_name INTO column1, column2;
EXIT WHEN cursor_name%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('Row ' || row_num || ': ' || column1 || ', ' || column2);
row_num := row_num + 1;
END LOOP;
CLOSE cursor_name;
END;
這些是在Oracle中獲取行號的幾種常見方式，可以根據具體情況選擇合適的方式來實現需求。
