PL SQL -Putting it all together скачать в хорошем качестве

PL SQL -Putting it all together

Writing a PL/SQL program to check if the given number is a prime number or not. Review Questions: 1. Which of the following is not true about labelling PL/SQL loops? A - PL/SQL loops can be labelled. B - The label should be enclosed by angle brackets. C - The label name appears at the beginning of the LOOP statement. D - The label name can also appear at the end of the LOOP statement or with an EXIT statement. 2. Write a PL/SQL code to print sum of even numbers between 1 and 100. 3. Write a PL/SQL code to print sum of odd numbers between 1 and 100. 4. Create a program to implement implicit cursor. 5. Create a program to implement explicit cursor. 6. Which of the following is equivalent to multiple IF-ELSIF statements? LOOP statement FOR statement WHILE statement CASE statement 7. What is %ROWTYPE used for?