RPAD number value

The number value is rpadable:


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, rpad(SAL,10),rpad(SAL,10,'.') from emp;

ENAME      RPAD(SAL,1 RPAD(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       1500......

11 rows selected.

SQL>
Home »
Oracle »
String Functions » 

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