DBMS | PL / SQL Example 1

Опубликовано: 26 Октябрь 2024
на канале: SP Tutorials
1,897
43

Create a table Student (Sid, Marks, Grade). Insert 5 records containing values of Sid and Marks. Write PL/SQL code to assign grade to every student based on their marks according to the following rules:
90 and above : O
80 to 89 : E
70 to 79 : A
60 to 69 : B
Otherwise : C

and update the table Student while doing so

We write PL/SQL code to carry out the above tasks