Re: Can I select(*) from T only fields that are not null?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 08 Jun 2005 23:20:02 +0200
Message-ID: <b6oea1h7a82vlshqt47vdcecsi0rc7u4e3@4ax.com>

On 8 Jun 2005 12:19:34 -0700, "deanbrown3d" <deanbrown3d_at_yahoo.com> wrote:

>Maybe I should add here that this is just for debugging and looking at
>a sparsely-populated table with most fields empty. Its a pain having
>SQLPlus be so wide sometimes.

No. It is a pain to have table definitions with all or most columns null allowed.
Next time: please shoot the developer, not the tool.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Jun 08 2005 - 16:20:02 CDT

This message: [ Message body ]
Next message: Barbara Boehmer: "Re: Trigger problem"
Previous message: Andy Hassall: "Re: Sum on like wildcard - replacing decode statement"
In reply to: deanbrown3d: "Re: Can I select(*) from T only fields that are not null?"
Next in thread: Maxim Demenko: "Re: Can I select(*) from T only fields that are not null?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US