Padding department with < and > : RPAD « Char Functions « Oracle PL / SQL






Padding department with < and >

 

SQL> create table departments
  2  ( deptno NUMBER(2)     constraint D_PK
  3                         primary key
  4  , dname  VARCHAR2(10)
  5  , location VARCHAR2(8)
  6  , mgr    NUMBER(4)
  7  ) ;

Table created.

SQL>
SQL> insert into departments values (10,'ACCOUNTING','NEW YORK',7);

1 row created.

SQL> insert into departments values (20,'TRAINING',  'DALLAS',  4);

1 row created.

SQL> insert into departments values (30,'SALES',     'CHICAGO', 6);

1 row created.

SQL> insert into departments values (40,'HR',        'BOSTON',  9);

1 row created.

SQL>
SQL> select dname
  2  ,      lpad(dname,9,'>')
  3  ,      rpad(dname,6,'<')
  4  from   departments;

DNAME      LPAD(DNAM RPAD(D
---------- --------- ------
ACCOUNTING ACCOUNTIN ACCOUN
TRAINING   >TRAINING TRAINI
SALES      >>>>SALES SALES<
HR         >>>>>>>HR HR<<<<

SQL>
SQL>
SQL> drop table departments;

Table dropped.

   
  








Related examples in the same category

1.Rpad: makes a string a certain length by adding (padding) a specified set of characters to the right
2.LPAD() and RPAD(): pad the input parameter of character data types with blanks (or another character) from the left or right
3.RPAD() function's behavior is identical to that of LPAD(), the only difference being the padding side.
4.select rpad( '*', 5, '*' )
5.Use rpad to add extra space