Toad World® Forums

columns alias bug


#1

Hi

Maybe I am reporting something already reported (a good search feature is lacking in these forums)
1-
select 20 myname from dual

gives
myname

20

2-
select dummy myname from dual

gives

dummy

X

3-
select dummy||dummy myname from dual
gives

myname

XX

It doesn’t uses the alias when only a column is used (2nd query) :frowning:

Regards
Filipe


#2

Hi Filipe,

This only happens when Updateable is ON. For the time being, please turn it off if you don’t need this option.

Gwen


#3

Gwen

You are right!

Thanks
Filipe