You missed the 'or' in my sentence. Maybe I should use || ? ;)
Jared "Marul Mehta" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 01:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: double quotes column name I guess this is not the case. 1. create table t("TABLE" Varchar2(10)); 2. select table_name,column_name from user_tab_columns where table_name='T'; TABLE_NAME COLUMN_NAME ------------------------------ ------------------------------ T TABLE Even though TABLE is a reserved word it appeared in uppercase when user_tab_columns was queried. Marul. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 11:38 PM > > how can we know that this table is created with "" column name > > When the column name is a reserved word, or appears with lower > case characters. > > Jared > > > > > > > "Harvinder Singh" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/21/2002 09:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: double quotes column name > > > 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: > 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: Marul Mehta 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: 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).