Searching is not always the best way. (eg ala Google) Instead look things
up by looking in the table of contents (SQL Reference, presents witha list
of functions, and the name is somewhat suggestive.)
Jim
"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message
news:qsTr9.35827$m92.6868536_at_news1.news.adelphia.net...
> Hmmm, sometimes that is sage advise, but searching tahiti.oracle.com for
> 'repeat character', or 'repeating character' or 'replicate character'
> produced NO hits. Going directly to LPAD and reading the write up made it
> seem that I would never have figured out a query to lead me to LPAD/RPAD.
>
> I agree that reading the manuals from cover to cover will enlighten one's
> mind, but sometimes that is impossible (jobs get in the way).
>
> i.e. just how can one search for something one doesn't know exists,
without
> spending one's life doing it?
>
>
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:h65vqugnim6u7klvd5uptqls4hrt2c1h21_at_4ax.com...
> > On 17 Oct 2002 20:31:53 -0700, pete.turner_at_geac.com.au (Pete Turner)
> > wrote:
> >
> > >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
> >
> >
> > Lpad and rpad.
> > Please look this up in the manual *before* posting questions you can
> > answer yourself easily.
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Fri Oct 18 2002 - 09:19:49 CDT
