SqlDbx Forum

SqlDbx

You are not logged in.

#1 2012-10-04 17:55:26

garbuya
Member

Small bug in results header

Try this
SELECT 'a'   --col1
            ,'b'   --col2
FROM DUAL

Why comments are in header??

Offline

#2 2012-10-04 23:19:25

sqldbxhelp
Administrator

Re: Small bug in results header

Because this is what Oracle returns.
SqlDbx sends to Oracle whatever query you created and displays whatever results come back.

Offline

#3 2012-10-05 09:19:30

garbuya
Member

Re: Small bug in results header

No, Oracle does not do it!!!
Oracle returns column headers 'a' and 'b'!!

Try to run this query in SQL*Plus or any other tool

Offline

#4 2012-10-05 21:04:57

sqldbxhelp
Administrator

Re: Small bug in results header

You have to realize that there's a difference between what Oracle Server does and how client application behaves.
Oracle does return comments as a part of result set.
What SQL*Plus does or any other application is up to them and not of my concern.
The only thing I can say that SqlDbx does not modify query you create or results returned.
By the way some other tools DO show comment as a part of the column header

Offline

Board footer

Powered by FluxBB