Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: create table issue

Re: create table issue

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Tue, 28 Jun 2005 18:46:06 +0530
Message-ID: <a144e52105062806166d4d3e60@mail.gmail.com>


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-l
Received on Tue Jun 28 2005 - 09:21:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US