Re: create table issue

From: Giovanni Cuccu <giovanni.cuccu_at_gmail.com>
Date: Tue, 28 Jun 2005 15:38:25 +0200
Message-ID: <23e0d117050628063812198439@mail.gmail.com>

Hi,

    I don't think there is an automatic way of getting these names since (but I'm not sure) the double quote mechanism is built in the sql parser. If you create a table named SELECT or INSERT and this names get into the data dictionary you cannot easily distinguish among other "regular" ones. You can extract these names but in my opinion it requires building a query/plsql proc that scans the column table_name of XXX_tables and checks if:

1) upper(table_name) is different from table_name
2) table_name contains some non a-z A-Z 0-9 characters
3) upper(table_name) is equal to one of reserved words (select or

insert for example).
I looked at the all_tables definition and I did not found anything that could help in finding "strange" names. Perhaps someone with more experience than me on this list can throw more light on this.
Giovanni  

On 6/28/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
> 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
>

-- 
--------------------------------------------------------------------
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
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 28 2005 - 09:43:49 CDT