>When I do a select like this:
>
>Select * from kpops.Patients patients
>
>
>Everything is fine. However, When I do it like this:
>
>Select * from kpops.Patients patients WHERE Patients.SEX = "M"
>
>I get an error. My question is:
>
>Does Oracle expect an index on the field you put the Where Clause on or is it something else?
>
>TIA Ron

It's something else. There is no requirement that a field be indexed that is included in a WHERE clause.