RE: SQL question
Date: Mon, 13 Oct 2008 17:32:51 -0700
Message-ID: <2A8185DC02A8CE4C8413E0A26A8A831A01D718B64D@XEDAMAIL2.ex.ad3.ucdavis.edu>
Jared,
I'm not sure I understand how that would help, there's no space in the data so INSTR(FOO,' ') returns zero. The dump returns this...
SQL> select * from mytable;
FOO
B B
- -
somelongishstring
A B
shorterstring
A C
shorter
A D
SQL> select dump(foo),dump(bar),dump(baz) from mytable; DUMP(FOO)
DUMP(BAR)
DUMP(BAZ)
Typ=1 Len=17: 115,111,109,101,108,111,110,103,105,115,104,115,116,114,105,110,10 3
Typ=96 Len=1: 65
Typ=96 Len=1: 66
Typ=1 Len=13: 115,104,111,114,116,101,114,115,116,114,105,110,103 Typ=96 Len=1: 65 Typ=96 Len=1: 67 Typ=1 Len=7: 115,104,111,114,116,101,114Typ=96 Len=1: 65
Typ=96 Len=1: 68
I have also tried
SQL> select substr(foo,0,length(foo)),bar,baz from mytable;
But the results are the same. I'm kinda stuck here.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
From: Jared Still [mailto:jkstill_at_gmail.com]
Sent: Monday, October 13, 2008 5:01 PM
To: William Wagman
Cc: oracle-l_at_freelists.org
Subject: Re: SQL question
You may want to try this to see what the non-printing characters are:
select dump(foo),dump(bar),dump(baz)
from mytable
/
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Mon, Oct 13, 2008 at 4:34 PM, William Wagman <wjwagman_at_ucdavis.edu<mailto:wjwagman_at_ucdavis.edu>> wrote: Greetings,
Running Oracle 10.2.0.3.0 on RHEL4, 64-bit.
Table:
foo VARCHAR2(300)
bar CHAR(1)
baz CHAR(1)
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 13 2008 - 19:32:51 CDT