cxscheid
asked on
Oracle SQL: selecting integer values and returning them right padded and left justified
Hi,
this might be an easy one: I'd like to select an integer data type, right pad with blanks so that there are 10 characters total and left-justify the output.
Example:
Select myInteger from table;
Should come out:
|999 |
(without the pipes but left justified and padded with blanks.
Thanks!
this might be an easy one: I'd like to select an integer data type, right pad with blanks so that there are 10 characters total and left-justify the output.
Example:
Select myInteger from table;
Should come out:
|999 |
(without the pipes but left justified and padded with blanks.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.