Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: String function to repeat a character

Re: String function to repeat a character

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 18 Oct 2002 04:14:37 GMT
Message-ID: <NULr9.80909$uF6.310369@rwcrnsc52.ops.asp.att.net>


try rpad
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/ a90125/functions105.htm#78725
from the docs:
RPAD
Syntax
rpad::=

Text description of rpad
Purpose
RPAD returns char1, right-padded to length n with char2, replicated as many times as necessary; char2 defaults to a single blank. If char1 is longer than n, this function returns the portion of char1 that fits in n.

Both char1 and char2 can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 datatype and is in the same character set as char1.

The argument n is the total length of the return value as it is displayed on your terminal screen. In most character sets, this is also the number of characters in the return value. However, in some multibyte character sets, the display length of a character string can differ from the number of characters in the string.

Example
The following example rights-pads a name with the letters "ab" until it is 12 characters long:

SELECT RPAD('MORRISON',12,'ab') "RPAD example"

     FROM DUAL; RPAD example



MORRISONabab
Basically, in the SQL guide.Jim"Pete Turner" <pete.turner_at_geac.com.au> wrote in message news:a7151261.0210171931.6b861789_at_posting.google.com...
> G'day,
>
> Does Oracle have an equivalent to the replicate() string function in SQL
Server?
>
> e.g. replicate('-',25) will return a string of 25 dashes.
>
> Pete
>
> Pete Turner
> Geac Computers Pty Ltd
> 208 Greenhill Road
> Eastwood
> South Australia 5063
>
> Phone: + 61 8 8372 6111 / Fax: + 61 8 8372 6199
> E-mail: pete.turner_at_geac.com.au

begin 666 functions65a.gif

M1TE&.#EAL (P`/<`````````/P``?P``P ``_P`J```J/P`J?P`JP `J_P!5
M``!5/P!5?P!5P !5_P!_``!_/P!_?P!_P !__P"J``"J/P"J?P"JP "J_P#5
M``#5/P#5?P#5P #5_P#_``#_/P#_?P#_P #__RH``"H`/RH`?RH`P"H`_RHJ
M`"HJ/RHJ?RHJP"HJ_RI5`"I5/RI5?RI5P"I5_RI_`"I_/RI_?RI_P"I__RJJ
M`"JJ/RJJ?RJJP"JJ_RK5`"K5/RK5?RK5P"K5_RK_`"K_/RK_?RK_P"K__U4`
M`%4`/U4`?U4`P%4`_U4J`%4J/U4J?U4JP%4J_U55`%55/U55?U55P%55_U5_
M`%5_/U5_?U5_P%5__U6J`%6J/U6J?U6JP%6J_U75`%75/U75?U75P%75_U7_
M`%7_/U7_?U7_P%7__W\``'\`/W\`?W\`P'\`_W\J`'\J/W\J?W\JP'\J_W]5
M`']5/W]5?W]5P']5_W]_`']_/W]_?W]_P']__W^J`'^J/W^J?W^JP'^J_W_5
M`'_5/W_5?W_5P'_5_W__`'__/W__?W__P'___ZH``*H`/ZH`?ZH`P*H`_ZHJ
M`*HJ/ZHJ?ZHJP*HJ_ZI5`*I5/ZI5?ZI5P*I5_ZI_`*I_/ZI_?ZI_P*I__ZJJ
M`*JJ/ZJJ?ZJJP*JJ_ZK5`*K5/ZK5?ZK5P*K5_ZK_`*K_/ZK_?ZK_P*K__]4`
M`-4`/]4`?]4`P-4`_]4J`-4J/]4J?]4JP-4J_]55`-55/]55?]55P-55_]5_
M`-5_/]5_?]5_P-5__]6J`-6J/]6J?]6JP-6J_]75`-75/]75?]75P-75_]7_
M`-7_/]7_?]7_P-7___\``/\`/_\`?_\`P/\`__\J`/\J/_\J?_\JP/\J__]5
M`/]5/_]5?_]5P/]5__]_`/]_/_]_?_]_P/]___^J`/^J/_^J?_^JP/^J___5
M`/_5/__5?__5P/_5____`/__/___?___P/____\``/\`/_\`?_\`P ```"HJ
M*E5557]_?ZJJJM75U?___R'Y! $``/\`+ ````"P`C ```C_`/\)'$BPH,&# M"!,J7,BPH<.'$"-*G$BQHL6+&#-JW,BQH\>/($.*'$FRI,F3*%.J7,FRI<N7 M,&/*G$FSILV;.'/JW,FSI\^?0(,*'4JTJ-&C2),J7<JTJ=.%_?;ITZ=O7S^* M_?8!U"=P(,&"!@7R\P?PG\"!! L:/(@PH<*%#!LZ? @QHL2)%"M:O(@QH\:- M'#MZ_ @RI,B1`OGER[>/'S]^^O+EZP=Q7[Y\^P#R$SB08$&#`O7ER]</X#^! M`PD6-'@084*%"QDV=/@08D2)$RE6M'@18T:-&SEV]/@19$B1(O7EXW=P7[Y] M#?OER]=OX[Y\^T:.'#ERY,B1(T>._QPY<N3(D2-'@M27SU_"?OGV+>R7;Y]'
M?_GTC1PY<N3(D2-'CAPY<N3(D2-'CO3(+Y^_A?WR]4OH+Q^_D/GVC1PY<N3(
MD2-'CAPY<N3(D2-'CNR8KU]#?OD2YMNW,%]#?OGR^2OH+U^_D2-'CAPY<N3(
MD2-'CAPY<N3(D1OYY7N8K]_!?OD8YF/H+]\_?OL,[LLW<N3(D2-'CAPY<N3(
MD2-'CAPY$J,_@?KX/=RW;Z"_@?KV,<S'D!\_@?D.YNLW<N3(D2-'CAPY<N3( MD2-'CAPYTJ*_?/[^Y?,'\)_ @00+\M,WL)\^@?GZ%12X+U^^?O_R[<NGSY^^ M?/KR"=2GC_]@OH("]?$#^$__at_0((%#1Y$F%#A0H8-'3Z$&%'B1(H5+5[$F%'C
M1HX=/7X$&5+D17_Y_.7S]Y!?/H+]]/G+=W ?OW_^^/W+)S!?/W\"\PG,YV_@
M/GX'^>4;.7+DR)$C1XX<.7+DR)$C1XX<&;$?0'X"!^[+E\\?P'\"!Q(LZ"\?
M0'X"!>[+EP_@/X$#_^4C^"^?P'S_^NW3ET]@/H'^]/$C2)!?/H#\! X4V _@
M/X$#"18T>!!A0H4+&39T^!!B1(D3*5:T>!%C1HT;.7;T^!%D2)$&^>7;QP^@ M/X$"^^7+YP_@/X$#"1;TEP^@/X$"]^7+!_"?P('_\@WT]R^?P'S_^O;Y^Y=/ M8#Z!^?P1)/B/GSZ __at_0.[,=O7SY^`/\)'$BPH,&#"!,J7,BPH<.'$"-*G$BQ MHL6+&#-JW,BQH\>/($.*'*B/WT%_^?SE\_>07SZ"^_3YRW=PW[Y__O;]RR<P M7SZ!_?()S/>/7S^%_/0IW+=OY,B1(T>.'#ERY,B1(T>.'#ERY#]]_1#F\_<O M7[^#^0[RTS>0GSZ!^?H9]*<O7SY___()S,<O7[Y]^03F^[<O7[Y\^0[JX[=P M'[^1(T>.'#ERY,B1(T>.'#ERY$B1_?8QU+?O(+^#^O8=W+=OI,!\_ACF\S=R MY,B1(T>.'#ERY,B1(T>.'!E27T-^^0[V_SN8K]_!?OE&_MN7KV&_?2-'CAPY M<N3(D2-'CAPY<N3(D2'S.<S'K^&^? GUZ1/9+Y\_A_E&CAPY<N3(D2.---)(
M%@'D3^! @@4-'D2($. __at_0,)%NSGSU_!@@4+%_at_3H3^! @@4-^@/X3^! @@4-
M#NSGS]_!@P<'^O/G[^#!@__\[3MXD%\^?P<)]LOG[Z! ?_GV'3QX\"!!?_GV
M'3SX+]_!@P?_^?,'\)_ @00+&CR(,*'"A0P;.GP(,:+$B10K6KR(,:/&C07U
M`<PG<"#!@@8/(CSH#^ __at_0,)_NNW#V ^@0+U\0/X3^! @@4']ML',)_ @00+
M&BS(#^ __at_0,)%O\<V&\?P'P"!>KK!_"?P($$"P[DIP]@/H$#]_D#^$__at_0((%
M">HS:'#@OGS]# [DEX^?P8+]\NDS:-"@08/]\NTS:)"@/H,&#?[;!S"?P('[
M`/X3.)!@08,'$294N)!A0X</(4:4.)%B18L7,6;4N%&@/GX<&^;SIU!?OGW]
M!OKCER]?/X?^].7;U\^?17_\\N7C]U!?OGW]!O;CER^?/X?]\N7;UV^@/W[Z
M\NV3J _BOGS[_!7TIR\?OX;^\N7CI[&?OGS\(NJ+R"^?/G[^!/KCER\?/XX< M.7+DR)$C1XX<.7+DZ% ?/XX-\_E#Z"^?/G\(]^7CQ[!?/GW^./;+IX__H;]\ M^OPAW)>O'\-]^?@E[)=/GS^(^B+ZRY<OG[Y]^O+ET^</(K]\^?3I`\A/X$"" M!0ONTY<OGSY_`/\)'$BPX$!]!@T2U)>OGT&!_?+I`_A/X$""!0T>1)A0X4*& M#1T^A!A1XD2*%2U>Q)A1HT9]_#8ZS.</8;Y]"_OEZZ?07[Y]&PGZRZ=O83Y] M"_?E\Z>07[Y^#/7E@[AOHC]^_/3QXU?1'S]^`/4)'$BP8,%]_/H!_"=P(,&"
M!O49-#AP7SY_!@GZR[</X#^!`PD6-'@084*%"QDV=/@08D2)$RE6M'@18T:-
M&?7Q.Y_at_O7[Y\^@3FRY<O7[^!_?(1S)<O7[Y^_PCS^3NH3]]!?@7YY5.8;Y_"
M?!#U%?27CU_"??D:[M.7L%^^?@[UZ7/H;]_&C1L9ZG/8+Y\__at_OW\&?27K]_&
MC1LW;MRX<>/&C1LW;L2HC]_!? /S\?N73Z"_? /WY>LW,)] ?_G\'<SGSZ"_
M?/X,]NMG,!\_A/SR+<SW<%\^@_WR)<S7SV&^?@CS[7OH+U^_AOSX;=RXD>&^
M?@WS\3.8[^"^?!LW;MRX<>/&C1LW;MRX$:,^?@?S#<S'[U^^@?D&YNNW;V"^
M@?WV'<SGSR _?0?W'>27#V&^?@OS.<R7+]]!??L.\LL'\)_ @00+[MM74&"_ M? 4+%A2X3U_!@@/S`?_\)W @P8(&#R),J' APX8#^^ECV"_?P7W]#N;SY]"A M0X<.'3ITZ-"A0X<.'3ITZ-"A0X<.'3ITZ-#AP7T"]?$[F&]@OG[_\@GTET^@
MOWW_\@W,1S#?P7S^!/KC)S ?OX/[$.;S-W"?P'[Y#N[+EZ_?OWS[\NG[YT]?
M/GWY_NG31S#?07[Y".X3J&^?PW_]\@WLQT__at_OGT']>7+E\^@OWP$]_DSR(^?
M0X<.'3ITN%!?/X3[!/+3=Y#?OH/Z^ WDY\^A0X<.'3ITZ-"A0X<.'3ITZ-"A
M0X<.'3ITZ-"A0X']]/W3Q^]@OGSY\ND3F"]?OGS]!/+K]V^?/X'Y".8[F,__ MW\!]^_[E\W<P'\)\_@;VT_=OWSZ#^_C]\\?O7SZ!^0#^Z^?OW[]\__+Y^_?O
MW[]\`/\)'"@PG[^!_?3]T\>/($&"`_WE(ZAOW[]\_0@.S.?O7SZ"`_/U&]@O
MGS^"_/0!_"=P(,&"!@\B3*AP(<.&!O/U.]A/WS]]^P[ZRW=PW[Z!_O+Y<^C0
MH4.'#ATZ=.C0H4.'#ATZ=.C0H4.'#ATZ=.A08#]]^O@=S#=0G[]_^0SJRY<O
M'S^!^0CF.YC/'\%]^_+Y.Y@/H3Y^!/OIT\?/8+Z"^03F$]AOG[Y\__(5S(<P MGS^"_?3IX^?PG[]\!?7MR^?O8#Z!^0[JXT>P7SY____ZZ=OGT*%#APX=.ORG M3U\_@_WTZ>.',-]!?OH(^LOGSZ%#APX=.G3HT*%#APX=.G3HT*%#APX=.G3H
MT.' ?@#U"1Q(4&"^?/P`_A,X\%^^@?SX_<M'4*"^@?H$YAO8;Q_!@?D`ZA,X
M,%\^?P#_"1SX+Q]!@@#U"1RH+U\^?@#_"1R8;Z"_?_D$YONG;Y^_?_G^Y1LH
M,-_ @0+S[0.H3Z# ?/GX`?PG<"#!@O[R`=0G<&"^?/X`_A,X\%\^@?D(#M2W
M#Z ^@0(!YA,H$* ^@0,)%C1X$&%"A0L9-E28+U\^@_GR\0/X3^! @?D(#N27 M#Z ^@0+SY0/X3^! @@4-'O]$F%#A0H8-'3Z$&%'B1(H5+5[$F%&CPW[Z]/$[
MF&\@/W[_\A7LQV]@/H'Y!NKS=S"?/X+[]N7S=U ?0GW\"/;3IX^?P7W[_OG;
M]R^?P'S_\@GLE^]?OH+Y$.;S1["?/GW\'OK+5U#?OGS^#N83F.^@/GX$^^7S
MMW'CQHT$^^G3Q^^@/WX'^>DCZ"^?OXT;-V[<N''CQHT;-V[<V+"?OG_Z^!W,
M-Y#?OG_Y"N[K-W!?OW_Y\N7+UP]A/G\#]^W[E\_?07T(\_D;V$_?OWW[#/K3
MER^?OW_Y!.;[QR]?OGWY_N4KF ]A/G\#^^G[IX_?P7P'_>4CJ&_?OWS]#N83
MF.__8+Y^`_OE\[=QX\:-!/OI^Z=OWT%^__at_X"W+?OW[]__O+Y`_A/X$""!0T>
M1)A0X4*&#1T^A!A1XD2*%2U>Q)A1H\-]`O7QV^@PG[^!_ 3FXW=P'\)\_@;N
M$]@OWT:%_/(1W"=0W[Z#_ [VRS>P'S^!^_9%])>/X#Y_&S=NW%APGT!^^@[J M0ZB/WT!^_C9NW+AQX\:-&S=NW+AQHT1]_#8ZS.?/(#]]!_WQ,\@O'\)\_38F MS+?O(+]\!_L=W+?O8+]\$??IV[AQXT:'_?(=Y(<PG[^-&S=NW+AQX\:-&S=N MW'A1'[^-#O/Y,^@OG[^#_0SFXX>07[Z-"/OE2YBOG\-\__T0YMOWT%\^?QLW M;MSX,-^^@OX0[LNW<>/&C1LW;MRX<>/&C1LQZN.WT6$^?P?WZ6O(+Y_"?/LV M&O27CU_"??D:`M2G#^ __at_0,']LO7CR!!@@+SZ0/X3^! @@4-'D284.%"A_at_T=
M/B38+Y\_AO[R]8,($2)$B! A0H0($2)$B! A0H0($2)$B! A'M3'#R+$A/G\
M(<RG;V&_?/T4^LNW#^)#?_GT+=2G;^&^?/X4\LO7CZ&^?! A0H0($2)$A_OR
M^5/H+]\^B! A0H0($2)$B! A0H0($2)$B! A0H0($2)"??P_at_0DR8SQ]"?_GT
M^4.X+U\_AOWRZ?,'D2&_?/H8^O_+I\\?PGWY^C'DEX]?PG[Y]$&$"!$B1(@0 M(>K+UP\AOWSZ($*$"!$B1(@0(4*$"!$B1(@0(4*$"!$B1(@)]?&#"#%A/G\* M]>7;U\^?0'_\\N7KY]"?OGS[^OF#:- ?OWSY^#W4EV]?/W\"^^W+E\^?PW[Y M\@'<U\_?OW_^^.G+MP_@/X$#"18T>!!A0H4+&39T^% AOWSY^/D3Z(]?OGS\ M($*$"!$B1(@0(4*$"!$B1(@0(4*$"!$B1(@*]0',)W @P8(&#R(\Z _@/X$# M"?[KMP]@/H$"]?$#^$__at_0((%!_K;!S"?P($$"QHDJ(\?P'\"!Q(L.-#?/H#Y M! K4UP_RX#^!`PD6',A/'\!\`@?R`_A/X$""!0T>1)A0X4*&#1T^=+@/8#Z! M`_<!_"=P(,&"!@\B3*AP(<.&#A]"C"AQ(L6*%B]BS*AQHT" __at_0.)%C0X$&$ M" '^$SB08$%__OP5+%BP8$& __at_0.)%C0H#^ _P0.)%C0X$!__OP=/'APH#]_ M_@#^$SB08$&#!Q$F5+B084.'#R$2].</X#^!`PD6-'@084*%"QDV=/@08D2) M$RE6M'@18T:-&SEV]/@19$B1(TF6-'D294J5*UFV=/D29DR9,VG6M'D39TZ= :.WGV]/D3:%"A0XD6-7H4:5*E2YDN#0@`.SL`
`
end Received on Thu Oct 17 2002 - 23:14:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US