fork download
copy 
  1.  
  2. DECLARE
  3. v_emp_hiredate EMP.HIREDATE%TYPE;
  4. v_mgr_hiredate EMP.HIREDATE%TYPE;
  5. v_emp_name EMP.ENAME%TYPE;
  6. v_annual_salary EMP.SAL%TYPE;
  7.  
  8.  
  9. FOR emp_rec IN (SELECT ENAME, SAL FROM EMP WHERE SAL > 2000) LOOP
  10. v_emp_name:= emp_rec.ENAME;
  11. v_annual_salary:= emp_rec.SAL*12; 
  12.  
  13. DBMS_OUTPUT.PUT_LINE('Employee Name Is: ' || v_emp_name || ' His Annual Salary= ' || v_annual_salary);
  14. END LOOP;
  15. END;
  16. /
Success #stdin #stdout #stderr 0.01s 8948KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Object: nil error: did not understand #'v_emp_hiredate'
MessageNotUnderstood(Exception)>>signal (ExcHandling.st:254)
UndefinedObject(Object)>>doesNotUnderstand: #'v_emp_hiredate' (SysExcept.st:1448)
UndefinedObject>>executeStatements (prog:2)
stderr
copy 
./prog:3: expected expression
https://ideone.com/QxYSqB
language:
Smalltalk (gst 3.2.5)
created:
12 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!