1.

The searched CASE statement has no selector in PL/SQL? Is this TRUE?

Answer»

Yes, we can label PL/SQL loops. Here are some key points about LABELS in a loop:

  • The label is enclosed by << and >> and appears at the BEGINNING of the LOOP statement.
  • The label name can also be included at the END of the LOOP statement.

Let us see an example:

DECLARE   i number(1);   j number(1); BEGIN   << outer >>   FOR i IN 1..5 LOOP      << inner >>      FOR j IN 1..2 LOOP         dbms_output.put_line('i = '|| i || ', j = ' || j);      END loop inner;   END loop outer; END; /

The output:

i = 1, j = 1 i = 1, j = 2 i = 2, j = 1 i = 2, j = 2 i = 3, j = 1 i = 3, j = 2 i = 4, j = 1 i = 4, j = 2 i = 5, j = 1 i = 5, j = 2


Discussion

No Comment Found

Related InterviewSolutions