sql - How to create a list of column names? -

i have question creating list of column names table. have table different activities football, basketball, volleyball,... want take of these sports , put them in list way can limit query later based on sport user selected in drop down. can mi problem?

select * activities (sleceted sport) = 'basketball'; 

if you're looking sql query you can here. or here.

select * all_tab_columns table_name = 'activities';