SQL question

From: FlameDance <FlameDance_at_gmx.de>
Date: Wed, 23 Jun 2004 23:39:27 +0200
Message-ID: <cbctag$r8q$01$1@news.t-online.com>

Hi everyone,

why does one of these very similar statements work and the other doesn't?

SQL> select distinct fa20, '2' from t_2;

       FA20 '
---------- -

          0 2
          1 2
          2 2
          3 2
          4 2
          5 2

6 Zeilen ausgewõhlt.

SQL> select '2', distinct fa20 from t_2; select '2', distinct fa20 from t_2

                     *

FEHLER in Zeile 1:
ORA-00936: Ausdruck fehlt

The error text translates to: Expression missing

Very curious,
Stephan Received on Wed Jun 23 2004 - 16:39:27 CDT