我对此功能clear columns
感到困惑。有人可以向我解释这一点。
我正在脚本中使用它。
clear columns
COLUMN temp_in_statement new_value str_in_statement
SELECT DISTINCT
LISTAGG('''' || MONTHCOVERED || ''' AS ' || to_char(MONTHCOVERED,'MONDDYYYY'),',')
WITHIN GROUP (ORDER BY MONTHCOVERED) AS temp_in_statement
FROM (SELECT DISTINCT trunc(MONTHCOVERED) as MONTHCOVERED FROM bbsm_aaa where trunc(MONTHCOVERED) between '01-AUG-19' and '31-OCT-19');
是否有特定列需要清除?还是我分配的所有列都被删除了?