Skip a fetch from the for / loop

[dudu0566]

I would like to know if you have any command that I can use inside a for / loop to jump to the next fetch.
I know that the Exit command interrupts the execution of the for / loop, I would only like that fetch was discarded.

Select all

 
for x in 0..10 
loop 
   if x = 4 then 
   <PULAR ESTE FETCH> 
   end if; 
   ... 
   ... 
 end loop 

grateful
Eduardo Gomes

[Trevisolli]

Brother,

By your code (FORM), you do not need FETCH.
He is implicit.

Just use your condition inside the expression.

[dudu0566]

Trevisolli may not express my question right.

What I want to know, as if within a loop I can skip that item and go to the next loop item.
For example the loop goes from 1 to 10, inside has some programming, but when it is 4 is not to perform, that is, from 1 to 3 it makes the normal loop, in 4 pula, from 5 to 10 does The normal loop.

grate

Eduardo

[Trevisolli]

Brother, beleza?

Would it be more or less?

Select all

 
-- Não listar 1 e 4 
BEGIN 
  FOR x IN 1..10 
  LOOP 
    IF x NOT IN (1,4) 
    THEN  
      dbms_output.put_line('Valor de x:'||x); 
    END IF; 
  END LOOP; 
END; 

If not, send us back, beleza?

[fsitja]

The fetch will always be sequential, the fetch itself is not pulse, but processing within the loop.
From what I understand this is what Trevisolli said or your cursor query is bringing lines you should not and you have to fix in SQL, which gets much more intuitive and less with "workaround" face.

[dudu0566]

Trevisolli and FSITJA

This Soluão meets my need.

But out of curiosity, there is no command that does this, like an abort, a next, or something like that ???

muito Thanks for everyone's attention.

Eduardo

[Trevisolli]

Brother,

From what I know, the only way out is you treat *** conditionally *** inside your loop.

If it is an explicit cursor, for example, you could work with% Rowcont and Tals.

Anything, send it there.

[dudu0566]

Trevisolli,
Your tip has already killed the problem here !!!!

Regarding the Command is Curiosity ....

Thanks for the attention

Eduardo

[dr_gori]

It does not make sense to make a "Next" in a cursor.
Type: Comes line per line, then you test that line X you do not need. But at that moment the line has come ... You already have it, that is, you already did the fetch. Bear?

Then, the best way out is to put inside SQL not to bring what you do not need. Or if it is not possible to do this, put the IF as Trevisolli suggested.

[papke]

Using continues to skip odd interacets

Select all

BEGIN 
  FOR n_index IN 1 .. 10 
  LOOP 
    -- skip odd numbers 
    IF MOD( n_index, 2 ) = 1 THEN 
      CONTINUE; 
    END IF; 
    DBMS_OUTPUT.PUT_LINE( n_index ); 
  END LOOP; 
END;

The output is:

Select all

2 
4 
6 
8 
10