Advertisement
Guest User

Untitled

a guest
Dec 8th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1.  
  2.  
  3. 1
  4. zalogować na użytkownika BBD_nazwisko
  5. 2
  6. Zawrappować procedurę
  7.  
  8. wrap iname - PROC2.sql oname - PROC2.plb
  9. W SQL*PLUS
  10. @PROC2.plb
  11.  
  12. Sprawdzić kod procedury
  13. SELECT line, text FROM USER_SOURCE
  14. WHERE name = 'PROC2' order by line;
  15.  
  16. 3
  17. CREATE OR REPLACE PROCEDURE PROC2...
  18. EXECUTE PROC2...;
  19.  
  20. SELECT line, text FROM USER_SOURCE
  21. WHERE name = 'PROC2' order by line;
  22.  
  23. Czy nadal jest zawrapowana?
  24.  
  25. 4
  26. SELECT DBMS_DDL.WRAP('create or replace function2(p1 NUMBER)...end;')
  27. FROMDUAL;
  28. 5
  29. BEGIN
  30. DBMS_DDL.CREATE_WRAPPED('CREATE OD REPLACE
  31. PACKAGE BODY Pakiet3 AS ..... END;')
  32. END;
  33. SELECT TEXT FROM USER
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement