Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!shaw.ca!sn-xit-03!sn-xit-04!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: trailing spaces Date: Fri, 12 Dec 2003 10:13:55 -0800 Organization: ATS Message-ID: <1071252740.728888@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 28 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:250001 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@x.washington.edu (replace 'x' with a 'u' to reply)