It sounds pretty easy to get column names from a table, right? Actually there is an answer to this question How to get column names from a table in Oracle?
The main problem is that the table belongs to another user. My user is for integration only and I do not have any database privileges.
Therefore, I can execute some kind of query: SELECT * FROM anotherUser.THE_TABLE;
But something like SELECT * FROM USER_TAB_COLUMNS
does not return rows.
Perhaps I can create queries on all_tab_columns, are there even faster parameters without procedures?
* This is an oracle database!
source share