Newsgroups: comp.databases.oracle.misc Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: How to stop new|old being printed. In-Reply-To: <1160667423.988776.110710@m7g2000cwm.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-70.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1160667423.988776.110710@m7g2000cwm.googlegroups.com> Mime-Version: 1.0 Date: Thu, 12 Oct 2006 16:45:36 GMT Lines: 38 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:130825 ian wrote: > Hi; > > How do I stop the:- > > old 236: '&&tel' > new 236: '048538' > old 473: and pm.orig_msisdn = '&&tel' > new 473: and pm.orig_msisdn = '048538' > >>From being reported from Sqlplus define tel = '048538';. > > SQL*Plus: Release 8.1.7.0.0 > > Regards > Ian > SET VERIFY OFF HTH, Brian -- =================================================================== Brian Peasland dba@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" - Unknown