OraFAQ Forum: Server Administration » Re: specify which position on a line to start printing a string

Home » RDBMS Server » Server Administration » Re: specify which position on a line to start printing a string

Thu, 26 July 2001 12:36

J.S HAN
Messages: 12
Registered: November 2000

Junior Member

Hi,
try to do this sql.

1* select rpad('bird',9,' ')||'cat' from dual
SQL> /

RPAD('BIRD',
------------
bird cat

Good luck!

Previous Topic:	Re: SQL Server 7 statement to Oracle 8i
Next Topic:	full table scans

Goto Forum:

]

Current Time: Tue Dec 24 06:38:02 CST 2024