ASSIGNMENT 1 SOLUTION WITH SOURCE CODE

Data Type and PL/SQL Block an Control Stratements

Contents:

  1. Set A
  2. Set B

Set A

Q 1. Write a PL/SQL block to accept a number and display multiplication table of the given number.

 Download code        Source code 

Q 2. Write a PL/SQL block which will accept student details, calculate the class using per value and insert the record into Student (rno, sname, class, per, class) table.

 Download code        Source code 

Q 3. Write a PL/SQL block which will accept two numbers from user, check whether numbers are positive or negative. If positive number then display only the odd numbers between the entered numbers.

 Download code        Source code 

Set B

Q 1. Write a PL/SQL block which will accept roll number of a student and display record of student from student table( use %ROWTYPE attribute).

 Download code        Source code 

Q 2. Write a PL/SQL block which will accept roll number from student, select name and percentage of the student and calculate grade using percentage value. Display the record.(use %TYPE).

 Download code        Source code 

Q 3. Write a PL/SQL block which will display ‘FYBBA(CA)’ ten times on screen. Odd index number must display ‘FYBBA(CA)’ and even index number position in reverse case ‘fybba(ca)’.

 Download code        Source code