Advertisement
Guest User

sir er code

a guest
Feb 12th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.36 KB | None | 0 0
  1. SET serveroutput ON;
  2.  
  3. DECLARE
  4.     theID money.id%TYPE := 0;
  5.     theTaka money.taka%TYPE := 10;
  6.  
  7.     CURSOR money_cur IS
  8.     SELECT id, taka FROM money;
  9. BEGIN
  10.     OPEN money_cur;
  11.  
  12.     LOOP
  13.         FETCH money_cur INTO theID, theTaka;
  14.         EXIT WHEN money_cur%notfound;
  15.         DBMS_OUTPUT.PUT_LINE(TO_CHAR(theID) || ' ' ||TO_CHAR(theTaka));
  16.     END LOOP;
  17.  
  18.     CLOSE money_cur;
  19.  
  20. END;
  21. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement