RE: double quotes column name
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 -- -- FF1access -- 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).
RE: double quotes column name
Harvinder, The columns created with double quotes show as such in user_tab_columns, i mean they show the name in the same case so... NameDisplayed Access - Access ACCess - ACCess and so on. and when u query the table use select Access FROM. Naveen -Original Message- Sent: Wednesday, August 21, 2002 9:59 PM 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 -- -- FF1access -- 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: Naveen Nahata 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).
RE: double quotes column name
Harvinder, The column won't be created with a quotation mark as part of its name. Oracle won't allow it. All the quotation mark does is allow the creation of the column in the first place, circumventing the syntax rules. This is not a good thing. I'll lay good odds that it causes problems somewhere down the line. Every time that column is referred to you'll have to enclose it in quotes. It's a terrible design choice. Go back to them and make them change it. Actually, as they're a client rather than a supplier you should advise them to change it. =) Flouting Oracle's object naming rules never did anyone any good. Regards, Mike Hately Oracle DBA -Original Message- Sent: Wednesday, August 21, 2002 9:59 PM 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 -- -- FF1access -- This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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).
Re: double quotes column name
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 -- -- FF1access -- 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).
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 -- -- FF1access -- 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).
Re: double quotes column name
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 -- -- FF1access -- 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).