1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Sample simple PROGRAM USING PARAMETERIZED CURSOR

DECLARE
    name emp.ename%type;
    dept emp.deptno%type;
    gsal emp.sal%type;

    cursor c1(salary number) is select ename,deptno,sal
    from emp where sal >salary;

BEGIN
open c1(3000);
dbms_output.put_line('NAME DEPARTMENT salary');
loop
fetch c1 into name,dept,gsal;
exit when c1%notfound;
dbms_output.put_line(name||' '||dept||' '||gsal);
end loop;
close c1;
END;

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy