Advertisement
Shailrshah

Name, Area and Phone number of a Customer in the Database

Oct 27th, 2013
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.17 KB | None | 0 0
  1. DECLARE
  2.     c       cust%ROWTYPE;
  3. BEGIN
  4.     SELECT * INTO c FROM cust WHERE cust_id = '&cust_id';
  5.     DBMS_OUTPUT.put_line(c.lname|| ' ' ||c.fname||' '||c.area||' '|| c.phone_no);
  6. END;
  7. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement