Re: ODBC " character issue

On 15 Sep 2006 10:34:20 -0700, soalvajavab1@xxxxxxxxx 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
.

Relevant Pages

  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... Senior Oracle DBA ... with the query and modify it to the way I need it and I could not get ... dynamic data back with that said how could I turn this into a dynamic ...
    (comp.databases.oracle.misc)
  • Re: How to prevent using shared pool with dynamic sql pivoting?
    ... aware of the new column to be displayed until I do the "ALTER SYSTEM ... FLUSH SHARED_POOL" or change some letters in the query. ... Only the session INSERTing will be able to SELECT the data courtesy of ... Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: Oracle Beginner Help
    ... >I'm trying to display data for employees that have the job as a clerk ... I write the following query ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.tools)
  • Re: Help needed for SQL Tuning...
    ... Can someone assist in better tuning this query? ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: local copy of remote database -- how to solve this case?
    ... I created a query that "generates" the script which i can run locally: ... and now I am stuck with indexes. ... Senior Oracle DBA ...
    (comp.databases.oracle.server)