RE: create table issue
- From: <Peter.Hitchman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2005 14:42:48 +0100
Hi,
There is a view v$reserved_words that lists all of the reserved words. So you
could use that to find tables/indexes etc created by surrounding the identifier
in double quotes.
So I just tried it:-
create table "InserT" ( dummy char(1));
select owner, table_name
from dba_tables d, v$reserved_words w
where upper(keyword) = upper(table_name)
---> OWNER TABLE_NAME
--------------- -----------------------------------
OPS$PHITCHMA InserT
1 row selected.
Regards
Pete
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Onkar N Tiwary
Sent: 28 June 2005 14:16
To: Giovanni Cuccu
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: create table issue
hi Giovanni,
Thanx for the reply. But u know my main doubt is how to find such object
created using quotes. It must be recognised differently by oracle shand there
ould be entry for such object. If I am not wrong. I am trying to find that
method where in we can find such objects created using quotes.
On 6/28/05, Giovanni Cuccu < giovanni.cuccu@xxxxxxxxx> wrote:
Hi,
I'm not a guru so my answer may be incorrect but I believe that
Oracle implicitly use the uppercase name of your item (table, but also
column, etc) when try to reference it. If you want to give an item a
"particular" name (as oracle 10g does with tables in the recyclebin)
you must enclose it with duble quotes; this indicates that the name
should be taken as you typed it. You can find all the names (in the
form required by Oracle for checking their existence) in the
corresponding data_dictionary view (dba_tables for examples).
Hope this helps,
Giovanni
On 6/28/05, Onkar N Tiwary < onkarnath.tiwary@xxxxxxxxx> wrote:
> Hi gurus,
>
> Normally oracle says we can not create tables using the keywords but when
> one issues CREATE TABLE "INSERT" (col datatype);", it gets created. It can
> always be referenced and other tasks can be done easily on the table but the
> table name must always be in double quotes. My question is how oracle
> identifies these tables and where does makes the entry of such tables for
> regonising? If I don know about this double quotes and the table has been
> created using double quotes then how to find such objects and from
> where?????
>
>
> --
> Thanks & Regards,
> T. Onkar Nath
> Ph : +91-9826728111(Cell)
> to_onkar@xxxxxxxxx
> onkarnath.tiwary@xxxxxxxxx
>
--
--------------------------------------------------------------------
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
New version 0.8 with many bug fixes
and warnings on file truncated, timed_statistics=false, incorrect
tracing deactivation and more
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx <mailto:onkarnath.tiwary@xxxxxxxxx>
Other related posts:
