Aligning number fileds in Oracle Forms Builder
Dear All,
In Form Builder, while displaying in the LOVs, how can I align the number fields? The number fileds aligned looks like the example given under:
Code Desc Amount Optr
5 AAA 4,55,265.56 DFLT
7 BBB 0.00 DFLT
9 CCC 3,05,123.75 DFLT
11 DDD 0.00 DFLT
How do I make the zeroes as well as the number fields with values right justified?
regards
Re: Aligning number fileds in Oracle Forms Builder
Quote:
Originally posted by ranjini
Dear All,
In Form Builder, while displaying in the LOVs, how can I align the number fields? The number fileds aligned looks like the example given under:
Code:
Code Desc Amount Optr
5 AAA 4,555,265.56 DFLT
7 BBB 0.00 DFLT
9 CCC 3,505,123.75 DFLT
11 DDD 0.00 DFLT
How do I make the zeroes as well as the number fields with values right justified?
regards
Conver the numbers to text using an TO_CHAR and LPAD.
LPAD(TO_CHAR(Amount, '99,999,999.99'), 15)