trying to use rpad but it does not display why

[csphard]

select rpad(mname,20) || rpad(mtype,20) || state from
(select 'Mickey Mouse' as mname, 'President' as mtype, 'California' as state from dual)

This comes out like Mickey Mouse President California.

Why did'nt I get my right paddings

Howard

 

[csphard]

Here is my problem. I am displaying first and last name with the title to the right. I would like the title to line up on the right.
Another example. I hope this one is better

select rpad(mname,20) || rpad(mtype,20) || state from
(select 'Mickey Mouse' as mname, 'Mouse' as mtype, 'California' as state from dual
union
select 'Donald Duck' as mname, 'Duck' as mtype, 'California' as state from dual
union
select 'Bugs Bunny' as mname, 'Rabit' as mtype, 'California' as state from dual
)

I want to have type line up I want the state to line up.
I thought that by putting in the padding it would pad them all to that lenght.
Meaning Bugs Bunny is 11 characteres so it would pad 9 more spaces.
Donald Duck is 10 characteres so it would pad 10 more spaces.

That way the type would line up. and the same with padding the mtype
Rabit is 3 characters to it would add 17.

How can I get this to happen?

 

[SantaMufasa]

I would like the title to line up on the right

I presume by this you want "text right alignment" to occur. For that, you want to use Oracle "LPAD()" function:

select lpad(mname,20) || lpad(mtype,20) || state from 
(select 'Mickey Mouse' as mname, 'Mouse' as mtype, 'California' as state from dual
union
select 'Donald Duck' as mname, 'Duck' as mtype, 'California' as state from dual
union
select 'Bugs Bunny' as mname, 'Rabit' as mtype, 'California' as state from dual
);

LPAD(MNAME,20)||LPAD(MTYPE,20)||STATE
--------------------------------------------------
          Bugs Bunny               RabitCalifornia
         Donald Duck                DuckCalifornia
        Mickey Mouse               MouseCalifornia

Let us know if this is what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[Thargy]

a mickey mouse solution, if ever I saw one!

Regards

T

 

[SantaMufasa]

What a "Goofy" thing to say. If I said, "It 'Bugs' me," I'd be lying, so I'll "Duck" the issue. <grin>

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”