RE: double quotes column name

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Wed, 21 Aug 2002 08:53:30 -0800
Message-ID: <F001.004BB44E.20020821085330@fatcity.com>

This is not a guaranteed method, but the fact that 'access' is stored in the data dictionary is an indicator that they used "" to force the name. Anytime you see lowercase, you can assume that they used "". Of course, if the created it as "ACCESS", my method won't work...

Dan Fink

-----Original Message-----

Sent: Wednesday, August 21, 2002 10:28 AM To: Multiple recipients of list ORACLE-L

Hi,

One of our clients has created a table with column name "access" since access is reserved word , they use double quotes..... but when i query the table user_tab_columns it is still showing column name as access and not "access"........
how can we know that this table is created with "" column name......

Thanks
--Harvinder

SQL> select table_name,column_name from user_tab_columns   2 where table_name='FF1'
  3 /

TABLE_NAME                     COLUMN_NAME


------------------------------ ------------------------------

FF1                            access

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Fink, Dan
  INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 21 2002 - 11:53:30 CDT