m_izzeddin

Salam Try this code Declare Cursor Abc Is Select * From Emp Where Deptno = 20; Begin For Rec In Abc Loop Dbms_output.Put_line ( 'name' || Rec.Ename || 'sal' || Rec.Sal || 'deptno' || Rec.Deptno ); End Loop; End; the output is nameSMITHsal800deptno20 nameJONESs…