| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
------------------------------ ------------------------------
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: Mike.Hately_at_churchill.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 13:13:34 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |