Re: Format of output in Sql*plus

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 20 Apr 2006 07:00:01 -0700
Message-ID: <1145541601.149206.273900@z34g2000cwc.googlegroups.com>

patrick wrote:
> It works for the heading, but the results are still strange. With
> spaces between the characters and broken off after 6 or 7 characters:
>
> ID_SOORT_GEDRAGING SUM(AANTAL_BEROEPEN)
> ----------------------------------------
> V L 0 33
>
> what else can i try?

Possibly the data is corrupted, or the display characterset does not match the database characterset in some way that is confusing SQL*Plus. That kind of thing is a bit dificult to reproduce, unfortunately.

Does this happen to all your data or just some of it? (And in all environments, or just SQL*Plus?)

Does

SELECT DUMP(id_soort_gedraging) ...

confirm that the missing values are present? Received on Thu Apr 20 2006 - 09:00:01 CDT