Re: HELP - Order by problem

> I'm using Oracle server 7.3.3.0.0 Why am I getting the
> following error in sql/plus
>
> SQL> update conv_observation_tables cot set ( person_id,role_type ) =
> 2 ( select person_id, role_type
> 3 from spi_survey_surveyors s1
> 4 where s1.spi_project_dc_id = cot.spi_project_dc_id
> 5 and rownum < 2
> 6 order by 1, 2 )
> 7 where observation_line_id = 4180;
> order by 1, 2 )
> *
> ERROR at line 6:
> ORA-00907: missing right parenthesis

Why is your second order by clause after the semicolon? And what is the asterisk doing after that? I am not going to try to guess what's wrong as it appears that you incorrectly copied the SQL.

Regards,

Dan Received on Tue Aug 18 1998 - 00:00:00 CDT