Re: Total beginner querying oracle tables

From: Bonnie R <bonvig_at_aol.com>
Date: 14 Feb 2003 08:20:36 -0800
Message-ID: <72187104.0302140820.3b4557c3@posting.google.com>

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:<BaY2a.92400$iG3.12074_at_sccrnsc02>...
> Does testtable exist? If not then that's the problem. Does AHVZDIS_DIS_D
> exist, if not then that's the problem. Log into sqlplus and do
> desc AHVZDIS_DIS_D
> and see if it exists
> and do
> desc testtable
> and see if it exists.
> Jim
>

I am using MS Access to run these queries. I don't have sqlplus. Testtable exists, but it is a local table to the Access database. I have been using ODBC to connect to the oracle database, and when I attempt to "link tables" I see the table I want in a list and the name on the list is "sfdata_ahvzdis_dis_d"

Any hope?!
B Received on Fri Feb 14 2003 - 10:20:36 CST