How to create a list of column names?

Question

I have a question about creating a list of column names from table. I have table with different activities like Football, Basketball, Volleyball,... I want to take all of these sports and put them in the list that way I can limit my query later based on the sport which user selected in drop down. Can anyone help mi with this problem?

Select *
From Activities
Where (sleceted sport) = 'Basketball';

I think usually you take integers as value and simply replace it with the names in the ui — Julian Berger, Jul 23 '15 at 16:24

score 0 · Answer 1 · edited May 23 '17 at 12:29

0

If you're looking for a SQL query to do this for you you can look here. Or here.

SELECT *
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'Activities';

edited May 23 '17 at 12:29

Community

1
1

answered Jul 23 '15 at 16:34

BJones

2,450
2
17
25

How to create a list of column names?

1 Answers1