RE: strange behaviour in select statement

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 28 Oct 2005 09:09:55 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKIELDHCAA.mwf@rsiz.com>

Seems like something fishy to me.

Let's see the sqlplus banner, set null ~, set feedback 1, and the actual query select * from tab; and select count(*) from tab;

IF there remains a mystery after that, then the details from dba_objects, dba_tables, and dba_indexes for this "table" and "show all" in the sqlplus session are in order.

Regards,

mwf
  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of raja rao   Sent: Friday, October 28, 2005 8:32 AM   To: lex.de.haan_at_naturaljoin.nl; stephenbooth.uk_at_gmail.com   Cc: 'oracle list'
  Subject: RE: strange behaviour in select statement

Yes, this is a heap table (not temporary table / view )

Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:

also, is this a "regular" heap table? or maybe a view with a hidden ROWNUM predicate? or an external table, or a global temporary table?

kind regards,

Lex.

Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On

    Behalf Of stephen booth
    Sent: Friday, October 28, 2005 10:02     To: raja4list_at_yahoo.com
    Cc: oracle list
    Subject: Re: strange behaviour in select statement

On 28/10/05, raja rao wrote:
>
> when i select more than 1 column, some colums data is missing. Am i
> missing something to setup.
>

The first thing that leaps to mind to try to identify the problem is to use

NVL() on both columns in your select to display something (the string 'this is

NULL' for example) if the value is null, or maybe do a select count(*) from

image_staging_table; to check there's only one row.

It's possible that your table might have two rows looking like:

HOSPITAL_ID ACCT#

------------- ASHFORD [NULL] [NULL] X104978978

rather than one row such as:

HOSPITAL_ID ACCT#

------------- ASHFORD X104978978

which is what you are presumably expecting.

Stephen

    --
    It's better to ask a silly question than to make a silly assumption.     --
    http://www.freelists.org/webpage/oracle-l

    BEGIN:VCARD
    VERSION:2.1
    N:de Haan;Lex
    FN:Lex de Haan

    ORG:Natural Join B.V.
    TEL;WORK;VOICE:+31.30.2515022
    TEL;HOME;VOICE:+31.30.2518795
    TEL;CELL;VOICE:+31.62.2955714

TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 SK=0D=0ANetherlands

    URL;WORK:http://www.naturaljoin.nl
    EMAIL;PREF;INTERNET:lex.de.haan_at_naturaljoin.nl     REV:20040224T160439Z
    END:VCARD

--
  Yahoo! FareChase - Search multiple travel sites in one click.



--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 28 2005 - 08:14:51 CDT