Re: suggestions for good graphical DB query builder

pamela fluente wrote:

> Dear Daniel ,
>
> The point is that it can do whatever Oracle can do just because it's
> letting Oracle do it! :-)

That is not true. Marketing hyperbole but not true. If you think otherwise than I would like to see a screenshot of the part of the GUI that provides the functionality to do this:

CREATE TABLE fpd (

dec_num    NUMBER(10,2),
bin_double BINARY_DOUBLE,
bin_float  BINARY_FLOAT);

INSERT INTO fpd VALUES (0, 'NaN', 'NaN'); COMMIT; SELECT * FROM fpd;

SELECT bin_double, NANVL(bin_double, 0)
FROM fpd;

Show me the GUI making available NANVL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org