How to export bill of material data from oracle to excel?

Without knowing the structure of the data, its hard to answer. You probably need your DBA to export the results of a query to CSV