RE: PL/SQL-if-statement

lerobe - Lee Robertson Fri, 20 Apr 2001 00:53:51 -0700

Title: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 April 2001 22:41
To: Multiple recipients of list ORACLE-L
Subject: 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:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
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" <[EMAIL PROTECTED]>@fatcity.com on 04/19/2001 11:40:54 AM

Please respond to [EMAIL PROTECTED]

Sent by: [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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

[EMAIL PROTECTED]

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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 is

confidential, is intended only for the use of the recipient

named above, and may be legally privileged. If the reader 

of this message is not the intended recipient, you are

hereby notified that any dissemination, distribution or

copying 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 computer

system.

RE: PL/SQL-if-statement

Reply via email to