Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Simple Question on WHERE
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