<div>
Look at the timestamps of the replies. &nbsp;Less than 2 minutes between them.<br />
<br />
I was typing mine while you were typing yours and you finished first. &nbsp;When I started typing my answer there was no other reply there.
</div>


Look at the timestamps of the replies.  Less than 2 minutes between them.

I was typing mine while you were typing yours and you finished first.  When I started typing my answer there was no other reply there.

<div>
thank you experts... I really appreciate your help
</div>


thank you experts... I really appreciate your help

<div>
And usually I'm the slow typist :-) No harm meant.
</div>


And usually I'm the slow typist :-) No harm meant.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
Oracle 11g: via sqlplus: connected to db successfully.<br />
<br />
I run: SELECT table_name FROM all_tables;<br />
I get all tables available....<br />
<br />
However, when I try to simple query such:<br />
SELECT * FROM tableName;<br />
I get: table does not exist<br />
<br />
is this a permission issue? <br />
Is there a way via the command line to know what permissions I have?<br />
<br />
Regards,
</div>
</div>


Hello Experts,

Oracle 11g: via sqlplus: connected to db successfully.

I run: SELECT table_name FROM all_tables;
I get all tables available....

However, when I try to simple query such:
SELECT * FROM tableName;
I get: table does not exist

is this a permission issue? 
Is there a way via the command line to know what permissions I have?

Regards,

Oracle 11g: sqlplus: though tables queried do exist, I get a 'table does not exist' when running query, why?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.