Advertisement
Guest User

Untitled

a guest
Jan 18th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1.  
  2. SQL> DECLARE
  3. 2 VAR1 VARCHAR2(20);
  4. 3 BEGIN
  5. 4 VAR1:= 'Hello Oracle';
  6. 5 DBMS_output.put
  7. 6
  8. 7
  9. 8 /
  10. DECLARE
  11. *
  12. ERROR at line 1:
  13. ORA-06550: line 7, column 0:
  14. PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
  15. following:
  16. := . ( @ % ;
  17.  
  18.  
  19. SQL> declare
  20. 2 var1 varchar2(20);
  21. 3 begin
  22. 4 var1:= 'Hello Oracle';
  23. 5 DBMS_output.put_line(var1);
  24. 6 exception
  25. 7 when others them
  26. 8 /
  27. when others them
  28. *
  29. ERROR at line 7:
  30. ORA-06550: line 7, column 13:
  31. PLS-00103: Encountered the symbol "THEM" when expecting one of the following:
  32. then or
  33.  
  34.  
  35. SQL> declare
  36. 2 var1 varchar2(20);
  37. 3 begin
  38. 4 var1:= 'Hello Oracle';
  39. 5 DBMS_output.put_line(var1);
  40. 6 exception
  41. 7 when others then
  42. 8 DBMS_output.put_line('Hell no');
  43. 9 end;
  44. 10 /
  45. Hello Oracle
  46.  
  47. PL/SQL procedure successfully completed.
  48.  
  49. SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement