From mark@cool-tools.co.uk Fri, 20 Apr 2001 01:44:55 -0700 From: "Mark Leith" Date: Fri, 20 Apr 2001 01:44:55 -0700 Subject: RE: PL/SQL-if-statement Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: PL/SQL-if-statement Yeah - I have hazy recollections of downing copious amounts of RB & Vodka a few years back too! In fact - my partner still does !! :)   Give it a try - it's a great drink!!! You'll be swimming laps of the pool all evening..   Mark   -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of lerobe - Lee RobertsonSent: Friday, April 20, 2001 09:21To: Multiple recipients of list ORACLE-LSubject: RE: PL/SQL-if-statement Erm... I hate to reinforce the popular myth about Brits. and their drinking but we have been doing the old "Red Bull and Vodka thing" for about 3-4 years now.   Have fun at the pool party Lisa   Hic !!!!!      -----Original Message-----From: Ed.Haskins@VerizonWireless.com [mailto:Ed.Haskins@VerizonWireless.com]Sent: 19 April 2001 22:41To: Multiple recipients of list ORACLE-LSubject: RE: PL/SQL-if-statement Pool Party?  Where?  I hear that the new power drink "Red Bull" tastes great with Absolut!!   -----Original Message-----From: Koivu, Lisa [mailto:lkoivu@qode.com]Sent: Thursday, April 19, 2001 5:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: PL/SQL-if-statement Hi Q, how's lovely MN? That was in response to other people in our company who have their self-important MS certifications spelled out in their entirety in their signature. Instead of spelling out 'Oracle Certified Professional - Database Administrator' in my signature I figured I could be creative.  The only title I nixed was Supreme Queen Office B*ch...  though it is rather appropriate.  I also was promoted to 'Senior Dba' last week but I don't think that's appropriate, either...  Titles are nothing !  They pay me way too much for how much goofing off I do. It's been a long week and tomorrow afternoon is Pool Party Time at my house.  Everyone's invited :)  Captain Morgan and Sir Absolut will be making an appearance. Cheers All!!! -----Original Message----- From: Brian_McQuillan@gelco.com [mailto:Brian_McQuillan@gelco.com] Sent: Thursday, April 19, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL-if-statement Lisa >Lisa Rutland Koivu >Oracle Database Administrator >Certified Self-Important Database Deity >Slayer of Unix Administrators > Wanton Kickboxing Goddess Love the new by line - it suits you well - but one question - is that Self Certified Self Important datavbase Deity or did you pass a special OCP exam for that ? ;-) Q "Koivu, Lisa" @fatcity.com on 04/19/2001 11:40:54 AM Please respond to ORACLE-L@fatcity.com Sent by:  root@fatcity.com To:   Multiple recipients of list ORACLE-L cc: Have you tried rpad() or lpad()? Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess lkoivu@qode.com  NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com <http://www.neom.com> www.paperclick.com <http://www.paperclick.com> www.qode.com <http://www.qode.com> P a p e r C l i c k . c o m <http://www.paperclick.com/home.htm>  Enter Your PaperClick Code Here! -----Original Message----- Sent: Thursday, April 19, 2001 10:56 AM To: Multiple recipients of list ORACLE-L How can I change  this pl/sql code, in the while-statement  maybe  so that if the field OWNER_NO is NULL, then it  should  be written six characters? The code looks like this: "IF  recCursor.OWNER_NO is null then vOWNER_NO := '000000'; else v_OWNER_NO:= to_char(recCursor.OWNER_NO); WHILE length(vOWNER_NO)  < 6 LOOP vOWNER_NO '0'0' || vOWNER_NO; END LOOP; END IF; How shoud I write to fix this script so therw will be written out 6 characters if the field OWNER_NO is empty. I want to use the WHILE LOOP. Any one whom can help me with this? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:   INET: Roland.Skoldblom@ica.se Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:   INET: Brian_McQuillan@gelco.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.