Re: Total beginner querying oracle tables

Bonnie R wrote:

> "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

I'd go down the hall, find a DBA, and have them install SQL*Plus on my machine and teach me to use it. MS Access is the front-end of last resort for stability, scalability, and performance. Not to mention it isn't worth much on a resume.

Daniel Morgan Received on Fri Feb 14 2003 - 10:36:26 CST