Geek asks and answers

Find table from query column name in oracle SQL developer

I want to query the database for the column name to find the table without knowing the table name (there are a huge number of tables)

I am currently working with a huge database and trying to find where, based on the CFML code and the URL of the problem page, the website retrieves the information. I am new to ColdFusion, but I see that the url contains several identity links with column names. I managed to find some of them easily and others, I have no idea, because the column names are rather vague, for example. 'NTASKID'.

My plan is to try to query a database using a column name, but Google has presented me with queries that require knowing a table name that I don't have. I think these examples could be more useful for denormalized tables (?).

If someone knows such a request, it would be great. Also, can anyone comment on whether I am on the right track of investigation here?

+5
source share
3 answers

The request that worked was

SELECT * FROM ALL_TAB_COLUMNS 
WHERE COLUMN_NAME LIKE '%TASK%' 
AND owner = 'database_name';

It was the “own” part that I did not know about before. Everyone who answered, of course, opened up opportunities for further search on Google.

Greetings

+12
source

, "juergen d" . , user_tab_columns/all_tab_columns, , table = 'YOUR_TABLE' - , .

+1

The IDE itself has a function for this: View> Find DB Obect

here is a 20 second video showing him in action

+1
source

More articles:


All Articles