Home » SQL & PL/SQL » SQL & PL/SQL » varchar2 with specific lenght
varchar2 with specific lenght [message #415190] Sun, 26 July 2009 03:14 Go to next message
obasad
Messages: 10
Registered: March 2006
Location: Riyadh
Junior Member

Hi ,
We have special requirement to select text column in fixed lenth.
In case select column is less than suggested lenth , we should add more space ' ' to reach that one.

For example i have to select emp_name in 10 charchter lenth . nut in the table we have only 6 charchters like 'George'.
Out should be like
'George '

Regards
Re: varchar2 with specific lenght [message #415192 is a reply to message #415190] Sun, 26 July 2009 03:23 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try rpad...

By
Vamsi
Re: varchar2 with specific lenght [message #415195 is a reply to message #415192] Sun, 26 July 2009 03:48 Go to previous message
obasad
Messages: 10
Registered: March 2006
Location: Riyadh
Junior Member

It is OK
Thanx very much
Previous Topic: update tablea based on data from tableb
Next Topic: procedure / function / package header declaration
Goto Forum:
  


Current Time: Sat Dec 10 09:24:28 CST 2016

Total time taken to generate the page: 0.30662 seconds