[PL SQL] Cursor Kullanımı

PROCEDURE exampleUseCursor(parameter1 IN VARCAR2, parameter2  OUT VARCAR2, parameter3  OUT VARCAR2)


cursor cursorName(parameter VARCHAR2) is
        Select * FROM tableName
        WHERE col1 = parameter AND col2='xx';
       
     cursorRow cursorName%ROWTYPE;

BEGIN

  -- .......
  -- .......

pen cursorName(parameterX);    
          
             LOOP
           
                fetch cursorName into cursorRow;
                exit when cursorName %notfound;
                   -- .......
                   -- INSERT INTO NEW_TABLE_NAME (col1, col2) VALUES (cursorRow.col1, cursorRow.col2);
                   -- .......
                   -- .......
              
             END LOOP;



  -- .......
  -- .......

END exampleUseCursor;