Guessing, might be good idea to use upper case names.
Oracle doesn't use country locale to define the difference between
upper case and lower case in the schema, which means that they
can use an arbitrary (American) distinction between upper case
and lower case, which means that they can support that part of
the SQL standard which expects table and field names to be in
upper case, and delimits names which are not.
(david)
<soalvajavab1[ at ]yahoo.com> wrote in message
news:1158341588.505734.238810[ at ]p79g2000cwp.googlegroups.com...
[Quoted Text] > 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
>
|