Answer to Question #190033 in C++ for jainab

Question #190033

Write a PL/SQL code to print all tables up to a number fetched from a table using implicit cursors.


1
Expert's answer
2021-05-06T16:05:57-0400
DECLARE 
    n_student students%ROWTYPE; 
BEGIN 
    SELECT * 
    INTO   n_student
    FROM   Student 
    WHERE  student_id = 5; 


    dbms_output.Put_line('Student Details :   ID:' 
                         ||n_student.student_id
                         ||'  Name: ' 
                         ||n_student.firstName 
                         ||' ' 
                         ||n_student.lastName 
                         ||'  Reg No:  ' 
                         ||n_student.regNo); 
END; 
/

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS