| Derby database [message #319878] |
Tue, 13 May 2008 05:48  |
|
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  |
Michel Cadot
Messages: 17605
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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]
|
|
|
| Re: Derby database [message #319947 is a reply to message #319878 ] |
Tue, 13 May 2008 08:04 |
joy_division
Messages: 2118
Registered: February 2005
Location: NY |
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.
|
|
|
]
Members
Search
Help
Register
Login
Home
