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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).