More than 1 filed in Select *

Hi all,

I am not able to complete the following problem, please help me.

Using the following table:

CREATE TABLE MYTEST
(
  COL1 NVARCHAR2(1),
  COL2 NVARCHAR2(1)
);

I can write: Select * from MYTEST;. (Obvious !!)

But I can't write: Select 0 as MYVALUE, * FROM MYTEST;

Error is: ORA-00936: missing expression

Why ?? Someone can help me ?

Many thanks in advance
Pietro Received on Thu Aug 31 2006 - 07:38:15 CDT