Get all the columns in a database at once in sql/apex

Question

I have a database called "cihe" is it possible to select all columns in the data base at once just the columns?(ps) im useing oracle apex to do this if it helps

Answer 1

You may try like this:

select COLUMN_NAME from ALL_TAB_COLUMNS 

You may also check ALL_TAB_COLUMNS