Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i LPAD and/or RPAD this query in sql

598146Feb 26 2008 — edited Feb 26 2008
Hi,

I have a column in a table with value 'True Wheel '. I want the result in the following format:
'True*Wheel*****'

i.e I want to pad '*' on the right as well as at the centre of the two words. Is it possible ?


Please help !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2008
Added on Feb 26 2008
1 comment
375 views