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?
In questa pagina del sito puoi guardare il video online PL SQL -Putting it all together della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Coding Christi -Python, Java, SQL 13 ottobre 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 618 volte e gli è piaciuto 15 spettatori. Buona visione!
