Re: HELP - Order by problem

The parentheses *are* unbalanced. You're missing a lefty. Lose the last paren.

EXE (exe_at_exesolutions.com) wrote:
: > 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

--
Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **