Databases | SQL | Oracle | MS Access Answers

Write a block in PL/SQL to print the specific number of rows from a table.

Write a PL/SQL program to display the description against a grade according to the marks achieved by students in their final exams.

Write a PL/SQL program to convert a temperature in scale Fahrenheit to Celsius and vice versa.

Draw the queue structure in each case when the following operations are performed on an empty queue.

(a) Add A, B, C, D, E, F

(b) Delete two letters

(c) Add G

(d) Add H

(e) Delete four letters

(f) Add I

Write a procedure and call it into main pl/sql program to find a factorial of a number.

Write a procedure to calculate factorial of a number entered by user.

Write a program in PL/SQL to show the uses of SQL%FOUND to determine if a DELETE statement affected any rows.

Write a block in PL/SQL to print the specific number of rows from a table.

Write a program in PL/SQL to print the value of a variable inside and outside a loop using LOOPEXIT statement.

Write a program in PL/SQL to show the uses of nested loop.