Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET serveroutput ON;
- DECLARE
- theID money.id%TYPE := 0;
- theTaka money.taka%TYPE := 10;
- CURSOR money_cur IS
- SELECT id, taka FROM money;
- BEGIN
- OPEN money_cur;
- LOOP
- FETCH money_cur INTO theID, theTaka;
- EXIT WHEN money_cur%notfound;
- DBMS_OUTPUT.PUT_LINE(TO_CHAR(theID) || ' ' ||TO_CHAR(theTaka));
- END LOOP;
- CLOSE money_cur;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement