What is the Output of the Following Program: declare n number:=2000; cursor c1 is select sal into n from emp where empno=7788; begin dbms_output.put_line(n); end; Data in Emp Table empno sal 123 1000

Keep practicing — related questions

• what will be the output of the following block: set serveroutput on; declare a int; b int; begin a:=NULL; b...
• Which line in the above code has an error? declare no number; sq number;begin no:=&number; --Line 1 if no>1...
• Declare Cursor c is select * from emp; I emp%row_type; Begin open c; fetch c into I; loop Dbms_output_line(...
• Begin Dbms_output.put_line(‘Hello world’) End; What is the error in the above block?
• What is the value of l_child_number? DECLARE l_parent_number NUMBER := 1; BEGIN DECLARE l_child_number NUMB...
• If emp table having 10 records what is the output of : select * from emp where rownum=8;
• DECLARE sal_limit NUMBER ( 4 ) := 0 ; my_ename emp.ename%TYPE ; my_sal emp.sal%TYPE ; CURSOR my_cursor IS S...
• If the below block, when you execute then what will be the output? Begin Null; Exception When others then D...