Understanding of Oracle SQL cursor

The "SQL" Mark written in the implicit cursor. For example, SQL % ROWCOUNT indicates that the implicit cursor has several rows of records. The explicit cursor is customized by the developer, you can also use C1 % ROWCOUNT to indicate the number of rows in the cursor C1. Usually, explicit cursors are opened in OPEN mode.

Use an explicitly defined cursor to OPEN it in OPEN mode. The usage is as follows:

1. Set serveroutput on
3. Declare
5. Cursor c1 is
7. Select rownum, table_name from user_tables where rownum <10;
9. V_rownum number;
11. V_tablename varchar2 (256 );
13. Begin
15. Open c1;
17. Dbms_output.put_line ('current row of cursor 1: '| c1 % rowcount );
19. Loop
21. Fetch c1 into v_rownum, v_tablename;
23. Exit when c1 % notfound;
25. Dbms_output.put_line ('cursor current row: '| c1 % rowcount | 'table_name:' | v_tablename );
27. End loop;
29. Dbms_output.put_line ('current row of cursor 2: '| c1 % rowcount );
31. Close c1;
33. End;

Run the command in SQLPUS to obtain the following result.

1. Current number of cursor rows: 0-1
3. Cursor current row: 1 table_name: T_SS
5. Cursor current row: 2 table_name: T_TARGET
7. Cursor current row: 3 table_name: T_SS_NORMAL
9. Cursor current row: 4 table_name: T_MYSTAT
11. Cursor current row: 5 table_name: T_WXL_GETDATA_LOG
13. Cursor current row: 6 table_name: ALL_OBJ
15. Cursor current row: 7 table_name: DBA_OBJ
17. Cursor current row: 8 table_name: T_RPT_XXX
19. Cursor current row: 9 table_name: CMS_DOC_BODY
21. Cursor current row

1 2 Next Page