col capture_name format a30 col parameter format a50 col value format a50 col set_by_user format a3 select capture_name,parameter, value,set_by_user from dba_capture_parameters where capture_name like upper('&capture_name') and parameter like '%CHECKPOINT%';