Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Simple Question on WHERE

Simple Question on WHERE

From: RS <sugarman_at_erols.com>
Date: 1998/03/13
Message-ID: <6ece81$egc$1@winter.news.erols.com>#1/1

Hello,

I'm using a product called Data Junction to transfer records from an Oracle 7.3 server to an MS SQL 6.0 server. The oracle table has around 1/2 million rows of which I want around 10k. Whenever I try to use a WHERE clause I get an error stating I have selected an invalid column. I know the column is typed correctly and I'm connecting to the server because I can attach to the table and down load a sample set of records when I don't use a WHERE.

While I'm familiar with MS SQL, I know nothing about Oracle and think I'm missing a keystroke or two. If someone could please tell me the correct syntax is for an Oracle WHERE ... AND ... statement I would greatly appreciate it.

Thank you in advance. Received on Fri Mar 13 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US