Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Format of output in Sql*plus
> I'm not sure I understand. The results are like this:
>
> DUMP(ID_SOORT_GEDRAGING)
> -------------------------------------------------------
> T y p = 1 L e n = 4 : 8 2 , 5 3 , 5 6 , 5 2
> T y p = 1 L e n = 5 : 8 6 , 7 1 , 4 8 , 4 8 , 5 6
> T y p = 1 L e n = 4 : 8 2 , 5 4 , 4 9 , 5 7
> T y p = 1 L e n = 4 : 8 2 , 5 4 , 4 8 , 5 0
> T y p = 1 L e n = 5 : 8 6 , 7 0 , 4 8 , 4 9 , 5 0
>
> Does this make sense?
Kinda....the above codes are the ASCII codes for the characters in that row of data. You can see the length of each attribute as well. For instance, in the first row, there is a value that is 4 bytes long. Using an ASCII chart, code 82='R', code 53='5', code 56='8', and code 52='4' so the output should be 'R584'. There are no spaces between those characters as spaces show up as code 32. And I do not see any hidden characters either.
But even the output of the above is odd as it contains spaces....Instead of:
T y p = 1 L e n = 4 : 8 2 , 5 3 , 5 6 , 5 2
The output should be:
Typ=1 Len=4: 82,53,56,52
So there is something odd about your SQL*Plus session. Do you get the same results if you use SQL Developer? You can download SQL Developer for free from Technet (http://technet.oracle.com) and it is a GUI version of SQL*Plus.
Otherwise, I'm at a loss to explain why you are getting those spaces in SQL*Plus. Those spaces are not in your data. Maybe you have some option set in SQL*Plus, but I can't think of what that would be.
Cheers,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu Apr 20 2006 - 09:55:21 CDT