Re: trailing spaces

Ravi Tallury wrote:

> Hi
> When i do a
> select '1' from dual from one instance of the database, i get only a
> single chanrecter.
>
> However when i run the same query from an other instance, i get a
> blank padded string. This has been causing problems in our application
> because of logic we use, any help in figuring out the reason and the
> remedy would be quite helpful.
>
> Thanks
> Ravi

In addition I'd suggest that someone log on as SYS and make sure that dual is defined as dual is supposed to be defined and that it contains one and only one record with the appropriate value.

If not ... fix it.

-- 
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)