select CAR collection

select c001 "action", c002 "assigned_to" , c003 "root_cause_analysis" , c004 "status", c006 "question",
       n001 "id", n005 "score",d001 "completion_date"
       from APEX_COLLECTIONS where collection_name = 'CORRECTIVE_ACTIONS';