Re: ODBC " character issue

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Sep 2006 20:03:41 +0200
Message-ID: <jjqlg2lioopev0lme86bua9dltt8fa5as5@4ax.com>

On 15 Sep 2006 10:34:20 -0700, soalvajavab1_at_yahoo.com wrote:

>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

There is:
Make sure ALL of your identifiers (table names, column names etc), are in UPPERCASE prior to conversion.
So
FF_TO_ORACLE
(ID
EMPID
EMPNAME
EMPDEPT
CREATE_DATE etc.

This is a known feature and has been documented here often. You could have searched http://groups.google.com prior to posting.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Sep 15 2006 - 13:03:41 CDT