Dynamic SQL formatting issue
Hi All,
I'm trying to write some dynamic SQL that reports a count of distinct values in each column for a given table.
I've written this:
------------------------------------------------
SPOOL COUNT_DISTINCTS.LST
SELECT 'SELECT '''||rpad(COLUMN_NAME,30,' ')||' '',COUNT(DISTINCT '||COLUMN_NAME||' ) FROM '||TABLE_NAME||';'
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = '&TABLE_NAME'
;
SPOOL OFF
@COUNT_DISTINCTS.LST
------------------------------------------------
Which gives this:
Code:
ACT_RTL_NON_RTL_GRPG 2
ACT_HOLDER_TYPE 1
ACT_HOLDER_CATEGORY 2
ACT_CORP_NON_CORP_IND 1
ACT_ATM_TRANS_ACT_IND 2
ACT_DORM_ACCOUNT_PRD_IND 1
-----------------------------------------------
How do I get the numbers to line up!?
Many thanks in advance.