Fixed column length with select query
Hello,
Oracle 10.2.0.1
Windows xp
I am having one table in which we have store customer name, address and phone numbers. I need the select query output in the fixed column (as column width) without removing trailing blank spaces for varchar2. When i gives :
select name || ' ' || add || ' ' || phone || ' ' || pin item from cust_table where rownum<=5;
It removes blank spaces from column values. I need them fixed length.
I need the addition of columns so that i can get one column and then i will populate in my dropdown list control.
I know for column <column_name> format command, but that is for sqlplus; while i need as select query output.
Please tell me, if i am unclear in my question anywhere.
Thanking you.