Re: Help! - MS Access --> O7 Windows
Date: Fri, 27 Jan 1995 01:35:30 GMT
Message-ID: <D31J36.8u1_at_indirect.com>
Douglas Hackney (hackneyd_at_ix.netcom.com) wrote:
: Problem: In exporting data from MS Access 2.0 to Oracle 7 for Windows
: (O7W) column names are being surrounded with "
: Background: I'm building a sales laptop system using O7W. The data is
: currently in a MS Access 2.0 database. The MS Access 2.0 Export:SQL
: Database:Oracle7 process works without a hitch, except that the column
: names are being preceded and followed with ". The " characters are not
: appearing when I query the system tables to show the column names, I
: discovered them by looking at the SQL string from a successful Browser
: test query.
: Using SQL Plus O7W reports "invalid column name" if I don't include the
: " (select smdemo.branch."city" from smdemo.branch), browser is seeing
: the " when it loads the schema, another query tool (Andyne GQL) is not
: seeing the " when it downloads the schema.
: Timeline: This system is due by the end of the week (typical bleeding
: edge development cycle).
: Questions:
: 1. is it possible to export from MS Access 2.0 to O7W without getting
: the " around the column names?
: 2. is it possible to edit the column names in O7W to remove the "?
An easy solution would be two create a new table with a select
statement .. for example
create table new_table as
select column_a a_column,
column_b b_column
from old_table;
By putting the alias for each column after the name of the column the new table is created with the new column name
: 3. is it possible to do a global search & replace on the column names in
: O7W to get rid of the "?
Their are tables which list all of the columns in the entire database.
In a version 6 rdbms there are data dictionary tables which
list all tables "dba_tab_columns" a user with dba privleges
Searching would be easy, for example
select user_name,table_name,column_name
from dba_tables
order by user_name,table_name,column_name;
the order by would be usefull to make sure you know which user and table each column belongs to.
I cant think of any way to change column names except by creating a new table.
: Any assistance would be appreciated.
: --
: -----------------------------------------------------------------------
: Doug Hackney Hackney-D_at_clavin.med.ge.com
: '94 RF900R '93 DR350S '87 GSX-R11 '72 Norton 750 Commando
........................................................................An unemployed dba
.................................................. sig version .9 beta Noah Monsey Oracle Master Database Administration April 92 noah_at_indirect.com Oracle Master Application Development April 92Received on Fri Jan 27 1995 - 02:35:30 CET