|
Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006
 Output format consulted?
I want to output the data in Oracle version, but it should be fixed format, such as name must be 30, the date (yyyymmddhh24miss) to be 18%, but left alignment, but do not know how to export to you?
- Intentioned people who tell me now anxious to die. |
Output format consulted?
Select LPAD ( 'a', 12 '0') AS abc
From dual
: For a field, and asked for a total length of 12 '0' demands for less than the length of the '0' premium
LPAD is left in place here can be used to meet the needs of LPAD |
Output format consulted?
Thank you, but there is a problem, figures show, he called two decimal, such as 1.2 to 1.20 request show with lpad how to achieve!
I use the left column was also published justify mistakes, but still shows at the right alignment.
Who used that way, quickly told me. |
| |
