Oracle PL/SQL - What is the output: code block?

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Introduction
  4. Variable Declarations

Question

What is the output of the following code? 

declare 
     v_length_nr NUMBER :=5.5; 
     v_width_nr  NUMBER :=3.5; 
     v_area_nr   NUMBER; 
begin 
     v_area_nr:=v_length_nr*v_width_nr                       
     DBMS_OUTPUT.put_line ('Area:'||area_nr);               
end; 
/


Click to view the answer

DBMS_OUTPUT.put_line('Area:'||area_nr); 
* 
ERROR at line 7: 
ORA-06550: line 7, column 5: 
PLS-00103: Encountered the symbol "DBMS_OUTPUT" when  
              expecting one of the following: 
 . ( * @ % & = - + ; < / > at in is mod remainder not rem 
 <> or != or ~= >= <= <> and or like 
between || member SUBMULTISET_ 
The symbol "." was substituted for "DBMS_OUTPUT" to  
             continue. 
SQL>

Note

When you have a missing semicolon, the error message you see might not identify the problem clearly.

Oracle tries to give you as much information as possible.

Related Quiz