netx_iit

procedure example 5

Nov 9th, 2020 (edited)
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.21 KB | None | 0 0
  1. SET serveroutput ON;
  2. DECLARE
  3. no1 NUMBER;
  4. PROCEDURE prc_sum(no1 IN OUT NUMBER)
  5. IS
  6. BEGIN
  7.     no1:=no1*no1;
  8. END prc_sum;
  9. BEGIN
  10.     no1:=&no1;
  11.     prc_sum(no1);
  12.     DBMS_OUTPUT.put_line('Square of number is '||no1);
  13. END;
  14. /
Add Comment
Please, Sign In to add comment