Re: PL/SQL functions

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Wed, 23 Aug 2000 18:47:09 -0700
Message-ID: <sq8vd76ct9193_at_corp.supernews.com>

"Sandy" <daleelaNOdaSPAM_at_usa.net.invalid> wrote in message news:176f8e61.25ce56b4_at_usw-ex0110-076.remarq.com...
> hi,
>
> I found for the leading zeros it is with to_char for numbers
> with the format 0999... but how can i do if the data
> contained in my variable is not a number like 'hello' if i
> want it to be ' hello' how can i do ?

Use the lpad (left-pad) function.

-Matt Received on Thu Aug 24 2000 - 03:47:09 CEST

This message: [ Message body ]
Next message: Brice Toth: "Populating Item from LOV in Forms 4.5"
Previous message: Sandy: "PL/SQL functions"
Maybe in reply to: Sandy: "PL/SQL functions"
Next in thread: Matt B.: "Re: Populating Item from LOV in Forms 4.5"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message