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 ------------------------------ ------------------------------ FF1 access -- ____________________________________________________________________________ ________________________ 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).
