Re: toad and double-quoting column name
- From: Iain Nicoll <iain.x.nicoll@xxxxxxxxxxxxxx>
- Date: Sat, 15 Sep 2007 09:21:31 -0500
Ken,
The table will have been created in double quotes as "table_a". Oracle
always looks for uppercase as will toad. Try select table_name from
aal_tables to show the difference - all other tables should be in
uppercase. I've never seen a good reason for doing this but that
doesn't stop people doing it.
ken quirici <ken.quirici@xxxxxxxxxx> wrote in
news:1189863591.875925.212320@xxxxxxxxxxxxxxxxxxxxxxxxxxx:
Hi,
I had an issue at work which has been bugging me since yesterday, so I
thought I might get some help before my weekend gets ruined.
I was in TOAD logged in to schema_1 which has privileges to read
schema_2
in the same database.
I tried
select count(*) from schema2.table_a;
and got an "unknown table" response from Oracle.
My dba suggested
select count(*) from schema2."table_a"
and it worked.
I didn't get a chance to ask him why, so my question is:
what is the nature of this function of double quotes in I assume
Oracle (rather than TOAD) functionality? In other words, does
Oracle have a rule like:
to access a table in a schema to which the schema you're in
has read access, enclose it's name in your sql statement in
doublequotes
I checked the master index of the Oracle 9i documents and found
only two refs to the doublequote, neither of which seemed relevant.
Thanks much for any ray of light.
Ken Quirici
.
- References:
- toad and double-quoting column name
- From: ken quirici
- toad and double-quoting column name
- Prev by Date: Re: How to solve probably a very simple DATE problem?
- Next by Date: Re: Require Solution for this SQL problem
- Previous by thread: Re: toad and double-quoting column name
- Next by thread: Re: toad and double-quoting column name
- Index(es):
Relevant Pages
|
