View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 08:06 AM
soalvajavab1@yahoo.com
 
Posts: n/a
Default ODBC " character issue

I export an access table using Oracle ODBC driver to Oracle schema,
it add character " to table name and all its column names like this

"ff_to_oracle"
(
ID VARCHAR2(20),
"empid" VARCHAR2(20),
"empname" VARCHAR2(50),
"empdept" VARCHAR2(20),
"create_date" DATE
)

and when I want to query the imported table in Oracle I have to say:

select * from "ff_to_otracle"


Is there anyway to get rid off " charater during the ODBC process?
Thanks for help

Reply With Quote