Re: create table issue
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: Peter.Hitchman@xxxxxxxxxxx
- Date: Wed, 29 Jun 2005 11:11:10 +0530
Hi Peter,
Nice method I must say. But what if a table has been created like this :
CREATE TABLE "TEST"(SR INTEGER);
In this case the table name is not the reserved word then how will one
identify this table as different from other tables created with normal
CREATE TABLE TEST(.....) command???
On 6/28/05, Peter.Hitchman@xxxxxxxxxxx <Peter.Hitchman@xxxxxxxxxxx> wrote:
>
> 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
>
>
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Other related posts:
