| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL-if-statement
Pool
Party? Where? I hear that the new power drink "Red Bull" tastes
great with Absolut!!
<SPAN
class=270473920-19042001>
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lkoivu_at_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_at_gelco.com [<A
href="mailto:Brian_McQuillan_at_gelco.com">mailto:Brian_McQuillan_at_gelco.com]
Sent: Thursday, April 19, 2001 4:21 PM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>Subject: RE: PL/SQL-if-statement
Lisa >Lisa Rutland Koivu
>Oracle Database Administrator <FONT
size=2>>Certified Self-Important Database Deity <FONT
size=2>>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" <lkoivu_at_qode.com>@fatcity.com on
04/19/2001 11:40:54 AM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> cc:
Have you tried rpad() or lpad()?
Lisa Rutland Koivu Oracle Database
Administrator Certified Self-Important Database
Deity Slayer of Unix Administrators <FONT
size=2>Wanton Kickboxing Goddess
lkoivu_at_qode.com
NeoMedia
2201 Second St., Suite 600 Fort Myers,
FL 33901, USA Phone: 941-337-3434 <FONT
size=2>Fax: 941-337-3668 www.neom.com <<A
href="http://www.neom.com" target=_blank>http://www.neom.com>
www.paperclick.com <<A href="http://www.paperclick.com"
target=_blank>http://www.paperclick.com> <FONT
size=2>www.qode.com <<A href="http://www.qode.com"
target=_blank>http://www.qode.com>
P a p e r C l i c k . c o m <<A
href="http://www.paperclick.com/home.htm"
target=_blank>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 <FONT
size=2>vOWNER_NO := '000000'; else <FONT
size=2>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
 |
 |