Advertisement
Guest User

Untitled

a guest
May 22nd, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1.  
  2. --CREATE OR REPLACE PROCEDURE PROC_ZAD_3(TBL_NAME IN VARCHAR2, COL_NAME IN VARCHAR2 := NULL)
  3. --IS
  4. -- TOTAL_RECORDS NUMBER := 0;
  5. -- COMMENT_TEXT VARCHAR2(50) := 'Total records: ';
  6. -- STMT VARCHAR2(500) := '';
  7. --BEGIN
  8. -- IF COL_NAME IS NULL
  9. -- THEN
  10. -- STMT := 'SELECT COUNT(*) FROM "' || TBL_NAME || '"';
  11. -- EXECUTE IMMEDIATE STMT INTO TOTAL_RECORDS;
  12. --
  13. -- COMMENT_TEXT := COMMENT_TEXT || TOTAL_RECORDS;
  14. --
  15. -- STMT := 'COMMENT ON TABLE "' || TBL_NAME || '" IS ''' || COMMENT_TEXT || '''';
  16. -- EXECUTE IMMEDIATE STMT;
  17. -- ELSE
  18. -- STMT := 'SELECT COUNT(*) FROM (SELECT DISTINCT "' || COL_NAME || '" FROM "' || TBL_NAME || '")';
  19. -- EXECUTE IMMEDIATE STMT INTO TOTAL_RECORDS;
  20. --
  21. -- COMMENT_TEXT := COMMENT_TEXT || TOTAL_RECORDS;
  22. --
  23. -- STMT := 'COMMENT ON COLUMN "' || TBL_NAME || '"."' || COL_NAME || '" IS ''' || COMMENT_TEXT || '''';
  24. -- EXECUTE IMMEDIATE STMT;
  25. -- END IF;
  26. --END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement