| valid column names [message #374] |
Thu, 07 February 2002 20:45  |
walker
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
I have a db that I need to import from MS Access. I pulled the tables into MS SQL server so that I could generate a ddl, but the ddl is failing when I try to run it in oracle's sqlplus.
the imported db has the following characters used in the column names:
spaces (ie. 'home phone')
/ (ie. 'm/m')
: (ie. 'cc:')
# (ie. 'emp#')
So my question is- is there a way to escape these characters in my create scripts, or does oracle not support these characters in colmun names?
I've looked for a reference for questions like these, and have come up empty. Even the oradocs don't seem to answer questions this basic!
Any help, urls, would be appreciated.
thanks
|
|
|
|
| Re: valid column names [message #376 is a reply to message #374] |
Fri, 08 February 2002 02:20  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
|
oracle only support the character # from your list.so you have to change your script manualy. oracle does support space you can say "home phone", but it is not a good idea.better u change it to home_phone
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
