From Ed.Haskins@VerizonWireless.com Thu, 19 Apr 2001 13:47:58 -0700 From: Ed.Haskins@VerizonWireless.com Date: Thu, 19 Apr 2001 13:47:58 -0700 Subject: RE: PL/SQL-if-statement Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: 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).