Use rpad function with define column default value : RPAD « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. RPAD
SQL>
SQL> create table t
  2  ( a int,
  3    b varchar2(4000) default rpad('*',4000,'*'),
  4    c varchar2(3000) default rpad('*',3000,'*' )
  5  )
  6  /

Table created.

SQL>
SQL> insert into t (a) values ( 1);

1 row created.

SQL> insert into t (a) values ( 2);

1 row created.

SQL> insert into t (a) values ( 3);

1 row created.

SQL>
SQL>
SQL> drop table t;

Table dropped.








11.12.RPAD
11.12.1.Rpad
11.12.2.RPAD(x, width [, pad_string]) pads x with spaces to right to bring the total length of the string up to width characters
11.12.3.RPAD() with number column
11.12.4.Call RPAD function in PL/SQL
11.12.5.Right padding the name of department
11.12.6.Use both lpad() and rpad() to create a string
11.12.7.Use RPAD to format cursor variable
11.12.8.Use rpad to represent the level
11.12.9.Use rpad function with define column default value
11.12.10.Use rpad to format a report