Home » SQL & PL/SQL » SQL & PL/SQL » Derby database (linux,Derby)
Derby database [message #319878] Tue, 13 May 2008 05:48 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
I have logged in deerby database.I have execueted the simple query like

show tables;

output:

aaa
ssss
aaaaaaaaaaaaaaaa&

And then i select data from aaaaaaaaaaaaaaaa& but it shows a error like table or view does not exist.

how can resolve this issues.


Thanks,
Michael
Re: Derby database [message #319879 is a reply to message #319878] Tue, 13 May 2008 05:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> show tables
SP2-0158: unknown SHOW option "tables"

Is this Oracle?

Oh no, this is Derby, but this is OraFAQ: Oracle's FAQ.

Try double quoting your table name.

Regards
Michel

[Updated on: Tue, 13 May 2008 05:52]

Report message to a moderator

Re: Derby database [message #319947 is a reply to message #319878] Tue, 13 May 2008 08:04 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
holdingbe wrote on Tue, 13 May 2008 06:48
Hi,
I have logged in deerby database.I have execueted the simple query like...



Quote:
but it shows a error like...



Don't tell us that you have done something "like" something. Tell us what you actually did. You said there was an error like "table or view does not exist." Why don't you tell us the actual error.
Previous Topic: increment the values of a column which contains PK
Next Topic: Varchar evaluation as timestamp
Goto Forum:
  


Current Time: Wed Dec 07 06:54:58 CST 2016

Total time taken to generate the page: 0.14250 seconds