Re: problems oracle 8.1.7.4

Using different table obviously, the adding of a column 'M' "TIPO" works ok in 8.1.7.4 and in 8.1.6.2 ... where the server is running on Solaris 8.

I used sqlplus from an 8.1.7.4 client home on W2K .

Just a wild guess based on little info, but I'd guess the tool you are using is the problem. Are you using sqlplus or something else?

-- 

"Jayme Assuncao Casimiro" <jayme_at_dcc.ufmg.br> wrote in message
news:Pine.GSO.4.21.0306060023400.17858-100000_at_turmalina.dcc.ufmg.br...

I'm doing the following query:

SELECT ID, TITULO, RESUMO, 'M' "TIPO" FROM TBOMDBMAT0;
The column Tipo doesn't exist in my TBOMDBMAT0 table. But I would like
that
it appears in my record set with the value M. This is not working on
8.1.7.4
version but it was working on version 8.1.6.?

Any sugestions?

+---------------------------------------------+


| Jayme Assuncao Casimiro                     |

| Graduado em Ciência da Computação           |

| Estudante de Mestrado em  Computação        |

| Universidade Federal de Minas Gerais - UFMG |

+---------------------------------------------+