Difference between revisions of "Table doesn't exist"

From SQLZOO
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 11: Line 11:
 
<div class = "link e-mimer">ORA-00942: table or view does not exist.</div>
 
<div class = "link e-mimer">ORA-00942: table or view does not exist.</div>
 
<div class = "link e-sybase">ORA-00942: table or view does not exist.</div>
 
<div class = "link e-sybase">ORA-00942: table or view does not exist.</div>
</div>
+
<div>
 
<h2>Problem</h2>
 
<h2>Problem</h2>
 
<p>An attempt was made to read from a table that does not exist.</p>
 
<p>An attempt was made to read from a table that does not exist.</p>
Line 41: Line 41:
 
</div>
 
</div>
 
</div>
 
</div>
 +
[[Category:Error]]

Latest revision as of 13:20, 9 August 2012

schema:gisq

Problem

An attempt was made to read from a table that does not exist.

Most likely the table name has been spelt incorrectly.

Possibly the table is not in the current schema or database.

Solutions

  • Correct the spelling of the table name.
 
 
SELECT * FROM Bbc
SELECT * FROM noSuchTable
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense