Re: create table issue

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_at_thomson.com <Peter.Hitchman_at_thomson.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of *Onkar N Tiwary
> *Sent:* 28 June 2005 14:16
> *To:* Giovanni Cuccu
> *Cc:* oracle-l_at_freelists.org
> *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_at_gmail.com> 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_at_gmail.com> 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_at_yahoo.com
> > > onkarnath.tiwary_at_gmail.com
> > >
> >
> >
> > --
> > --------------------------------------------------------------------
> > 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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
>

-- 
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l