Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CREATE OR REPLACE PROCEDURE PROC_ZAD_3(TBL_NAME IN VARCHAR2, COL_NAME IN VARCHAR2 := NULL)
- --IS
- -- TOTAL_RECORDS NUMBER := 0;
- -- COMMENT_TEXT VARCHAR2(50) := 'Total records: ';
- -- STMT VARCHAR2(500) := '';
- --BEGIN
- -- IF COL_NAME IS NULL
- -- THEN
- -- STMT := 'SELECT COUNT(*) FROM "' || TBL_NAME || '"';
- -- EXECUTE IMMEDIATE STMT INTO TOTAL_RECORDS;
- --
- -- COMMENT_TEXT := COMMENT_TEXT || TOTAL_RECORDS;
- --
- -- STMT := 'COMMENT ON TABLE "' || TBL_NAME || '" IS ''' || COMMENT_TEXT || '''';
- -- EXECUTE IMMEDIATE STMT;
- -- ELSE
- -- STMT := 'SELECT COUNT(*) FROM (SELECT DISTINCT "' || COL_NAME || '" FROM "' || TBL_NAME || '")';
- -- EXECUTE IMMEDIATE STMT INTO TOTAL_RECORDS;
- --
- -- COMMENT_TEXT := COMMENT_TEXT || TOTAL_RECORDS;
- --
- -- STMT := 'COMMENT ON COLUMN "' || TBL_NAME || '"."' || COL_NAME || '" IS ''' || COMMENT_TEXT || '''';
- -- EXECUTE IMMEDIATE STMT;
- -- END IF;
- --END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement