[مخالف - طلب حل : ]سؤال

السلام عليكم خواني أخواتي...

أرجوا منكم الرد على الأسئلة التالية بأسرع وقت..السؤال مختص بمادة SQL....

1-Write a PL/SQL block to display Fibonacci series from 1 to 25.Create a table and store the generated series into it.The PL/SQL block should also display sum of the numbers in the series.

Fibonacci series :1,1,2,3,5,8,13,21.

2- create a student table withe the following fields:

student_ID (primary key)

student_Name

Marksl

Grade

Insert 5 records into the above created table having stud_ID values from 1to 5 and leave the grade field blank.

write a PL/SQL block to update the GRADE field based on the following conditions

for Marks <50, Grade should be 'F'

for Marks from 50 to 60,Grade should be'C'

for Marks from 61 to 80,Grade should be'B

for Marks from 81 to 100,Grade should be'A

واتمنى الي يعرف الحل يفيدنا بإجاباته

وشكراااااااااااااااا جزيلا لكم

ارجواااااااااااااااااا الرد ع السؤ ال لو تكرمتوا