Some PL/SQL

Albatross

Platinum Member
Jul 17, 2001
2,344
8
81
DECLARE
x NUMBER(2);
BEGIN
x:=22;
FOR v IN 1..5 LOOP
IF v NOT IN (8,9) THEN
INSERT INTO lucru VALUES(v);
END IF;
END LOOP;
END;
/

Could somebody enlighten me how this sequence writes 2 in the table?
It`s from a multiple choice test it only says that the name of the table is lucru.
 

Tea Bag

Golden Member
Sep 11, 2004
1,575
3
0
Based on what you've posted and assuming there's no table constraints or underlying triggers, this inserts a record for 1-5 in the 'lucru' table. So '2' is one of the records written.

it seems somewhat incorrect or missing a few parts as the variable x is not referenced at all within the loop.
 

Albatross

Platinum Member
Jul 17, 2001
2,344
8
81
Based on what you've posted and assuming there's no table constraints or underlying triggers, this inserts a record for 1-5 in the 'lucru' table. So '2' is one of the records written.

it seems somewhat incorrect or missing a few parts as the variable x is not referenced at all within the loop.

Yeah,probably something is missing.Thanks.
 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |