| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Question on WHERE
A copy of this was sent to "RS" <sugarman_at_erols.com> (if that email address didn't require changing) On Fri, 13 Mar 1998 17:58:50 -0500, you wrote:
>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.
>
I'm gonna guess on this one (the query in question would help)....
In MS SQL:
where column = "Constant"
is the same as:
where column = 'Constant'
In Oracle (and ANSI sql in general) these two statements are very different.
where column = "Constant" means where the database column column is equal to the database column named (with case preserved) Constant.
where column = 'Constant' means where the database column column is equal to the STRING Constant.
You probably are using double quotes, use single quotes and it'll work.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Mar 14 1998 - 00:00:00 CST
 |
 |