sasfvs

Untitled

Jul 5th, 2017
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.53 KB | None | 0 0
  1. SET SERVEROUTPUT  ON; -- With this the server communicates with you!
  2. DECLARE
  3.     test VARCHAR2(15); -- delcaration without any data of cvariable test
  4.     test_a VARCHAR2(15) := 'nliplace.com'; --here we declare and initialize the variable test_a
  5. BEGIN
  6.     test_a := 'testvalue';  -- Here we initialize in execution block
  7.     DBMS_OUTPUT.PUT_LINE(test); -- Here we request to the server to print the value of the variable
  8. EXCEPTION
  9.     -- Here you make exceptions
  10. END; -- Here you end everything for this block
  11.  
  12.  
  13. -- the output will be "testvalue"
Advertisement