Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP - Order by problem

Re: HELP - Order by problem

From: Jared Hecker <jared_at_pandora.planet.net>
Date: 1998/08/21
Message-ID: <6rjps6$g8@jupiter.planet.net>#1/1

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 **
Received on Fri Aug 21 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US