Re: Newbie Oracle SQL question

petemarrin54_at_hotmail.com (Peter J Marrin) writes:

> I can't get Oracle to handle this type of query:
> SELECT *, 'hello' AS Greeting FROM table

Try this:

  seleect table.*, 'hello' AS Greeting FROM table; or   seleect t.*, 'hello' AS Greeting FROM table t;

Harald Received on Wed Aug 27 2003 - 13:35:08 CDT