Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 28 2005 - 09:21:29 CDT
![]() |
![]() |