LPAD number value

The number value is lpadable:


CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,
                  ENAME VARCHAR2(10),
                  JOB VARCHAR2(9),
                  SAL NUMBER(7, 2),
                  DEPTNO NUMBER(2));

INSERT INTO EMP VALUES (1, 'SMITH', 'CLERK',     800,    20);
INSERT INTO EMP VALUES (2, 'ALLEN', 'SALESMAN', 1600,    30);
INSERT INTO EMP VALUES (3, 'WARD',  'SALESMAN', 1250,    30);
INSERT INTO EMP VALUES (4, 'JONES', 'MANAGER',  2975,    20);
INSERT INTO EMP VALUES (5, 'MARTIN','SALESMAN', 1250,    30);
INSERT INTO EMP VALUES (6, 'BLAKE', 'MANAGER',  2850,    30);
INSERT INTO EMP VALUES (7, 'CLARK', 'MANAGER',  2850,    10);
INSERT INTO EMP VALUES (8, 'SCOTT', 'ANALYST',  3000,    20);
INSERT INTO EMP VALUES (9, 'KING',  'PRESIDENT',3000,    10);
INSERT INTO EMP VALUES (10,'TURNER','SALESMAN', 1500,    30);
INSERT INTO EMP VALUES (11,'ADAMS', 'CLERK',    1500,    20);

SQL> select ename, lpad(SAL,10),lpad(SAL,10,'.') from emp;

ENAME      LPAD(SAL,1 LPAD(SAL,1
---------- ---------- ----------
SMITH             800 .......800
ALLEN            1600 ......1600
WARD             1250 ......1250
JONES            2975 ......2975
MARTIN           1250 ......1250
BLAKE            2850 ......2850
CLARK            2850 ......2850
SCOTT            3000 ......3000
KING             3000 ......3000
TURNER           1500 ......1500
ADAMS         1500.12 ...1500.12

11 rows selected.

SQL>
Home »
Oracle »
String Functions » 

LPAD:
  1. LPAD function
  2. LPAD number value
Related: