Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR CURSOR IS SELECT * FROM cust;
- cust cursor%ROWTYPE;
- BEGIN
- DBMS_OUTPUT.PUT_LINE('*********************************');
- OPEN CURSOR;
- FETCH CURSOR INTO cust;
- WHILE cursor%found LOOP
- DBMS_OUTPUT.PUT_LINE(cust.fname||' '|| cust.lname ||'('||cust.area||')'||': '|| cust.phone_no);
- DBMS_OUTPUT.PUT_LINE('*********************************');
- FETCH CURSOR INTO cust;
- END LOOP;
- CLOSE CURSOR;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement