Answer to Question #268510 in Databases | SQL | Oracle | MS Access for Lee

Question

Write a pl /SQL anonymous block that will prompt the user to enter a particular student number and the displays the students registration information

Answer 1

DECLARE
stu_number student.studid%type;
stu_name  student.name%type; 
stu_gender student.gender%type; 
stu_course  student.course%type; 
begin
stu_number := :stu_number;
SELECT name, gender, course INTO stu_name, stu_gender, stu_course FROM student WHERE studid = stu_number;
dbms_output.put_line('Student Name is: '||stu_name||' Gender is: '||stu_gender||'Course is: '||stu_course);
end;