Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: goal_name is different andso is length of string

Re: goal_name is different andso is length of string

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 31 May 2004 13:23:50 -0700
Message-ID: <1086035038.114207@yasure>


Noel wrote:

>>SQL> select 'kk' from dual;
>>
>>'kk'
>>--------------------------------
>>kk

>
>
> And select length('kk') from dual says 3 ?
> --
> TomekB

I have no idea what it is you think the above is doing. But if you truly want to understand something then:

SELECT dump('kk') from dual;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon May 31 2004 - 15:23:50 CDT

Original text of this message

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