-1

When I using this statement in Oracle to view the values of a table_name, I got this:

SELECT * FROM MEMBER

and I got this result

Table does not exist. ORA-00942: table or view does not exist

This means the table values can not be display with SELECT statement?

  • Usually there is no schema named user_tables in Oracle. Did you create such a user/schema? If yes, then show us the create table statement for the table table_name. – a_horse_with_no_name Aug 30 '16 at 6:37
2

I would try the following statement to retrieve the owner of the object:

select owner, object_name, object_type from ALL_OBJECTS where object_name = 'MEMBER';

Referenced here

Then depending on the result(s) returned you would adjust your statement to something like this:

SELECT * FROM  <owner>.MEMBER;

...and replace <owner> with the owner that was returned in the first statement.

0

That is not how you select a specific column. Use this:

SELECT table_name FROM user_tables
  • Yes I can list all table_name, but I can not list data value in any table with statement select * from – learnscript Aug 30 '16 at 6:36
  • I have edited my question a little bit for easy understand. – learnscript Aug 30 '16 at 6:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.