Oracle 11G table exists but not usable

Question

I'm running Oracle 11G. Assume I have table named TEST_TABLE. I can see it when run :

SQL> SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME='TEST_TABLE';

TABLE_NAME
------------------------------
TEST_TABLE

But when I try to get table content I get an error:

SQL>  SELECT * FROM table (TEST_TABLE);
SELECT * FROM table (TEST_TABLE)
                  *
ERROR at line 1:
ORA-00904: "TEST_TABLE": invalid identifier

Any help will be greatly appreciated !

SELECT * FROM TEST_TABLE;

Kirill Leontev
– Kirill Leontev

2013-03-15 12:07:54 +00:00
Commented Mar 15, 2013 at 12:07 — Kirill Leontev
– Kirill Leontev, Commented Mar 15, 2013 at 12:07

Thilo · Accepted Answer · 2013-03-15 12:14:05Z

2

SELECT * FROM table (TEST_TABLE);

That is the syntax for using a table function. Quite an advanced topic, not what you are looking for.

To access a table, simply do

SELECT * FROM TEST_TABLE;

answered Mar 15, 2013 at 12:14

Thilo

264k107 gold badges527 silver badges674 bronze badges

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

1 Comment

user1990511 Over a year ago

Thanks a lot ! Now everything fine !

Collectives™ on Stack Overflow

Oracle 11G table exists but not usable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related