Due to limitations in my GIS software, I need to write select queries for each of my 200+ tables in my database. The queries need to select all columns, except for one, the SHAPE column.
Is there an efficient way to get all the field names for each table - for the purpose of writing select queries?
What I've tried:
I think this is possible with SQL Developer(free). But unfortunately, I don't have SQL Developer, due to I.T. challenges.
I'm aware that when I create a
SELECT *view on a table in Oracle, the query is translated to explicitly select individual fields. So I could a) create a
SELECT *view for each table, b) get the view definition, and c) write the query for each table. This is probably quicker than manually typing each field name, but not by a lot.
How can I efficiently write select queries for tables with lots of columns?