Retrieve column name through db link in Oracle 11g

Question

I want to retrieve column names from a table through a db link but I'm not able to do it...

Although this query is working

SELECT *
FROM myTableName@myDbLink;

the following one is not:

SELECT column_name
FROM all_tab_columns@myDbLink
WHERE table_name = 'myTableName'

What's the correct way of retrieving the column names?

Littlefoot · Accepted Answer · 2018-03-12 09:15:38Z

4

CaSE mATterS.

In Oracle, table names are - by default - in UPPERCASE, so - try with

SELECT column_name
FROM all_tab_columns@myDbLink
WHERE table_name = 'MYTABLENAME'

answered Mar 12, 2018 at 9:15

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

JaviOverflow Over a year ago

if myTableName in the select works, why should 'MYTABLENAME' works?

Kaushik Nayak Over a year ago

@JaviOverflow : Please read stackoverflow.com/questions/7425153/…

JaviOverflow Over a year ago

That's really interesting! I didn't know that. However, when I use "myTableName" in my select query, it's still working, so I guess I'm using the same-case-sensitive name.

Littlefoot Over a year ago

Mixed case is evil, avoid creating Oracle objects using mixed case. If you want to do that, you'll have to use double quotes. And if you do that, you'll have to use double quotes everywhere, always, whenever you reference that object, and never fail letter case.

Collectives™ on Stack Overflow

Retrieve column name through db link in Oracle 11g

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related