|
Other SQL databases support LPAD and RPAD with two parameter. If the third parameter is omitted, it means padding with space by default.
$ psql
|
psql (9.4.9)
|
Type "help" for help.
|
|
bar=> SELECT LPAD('a',10);
|
lpad
|
------------
|
a
|
(1 row)
|
$ sqlplus system/manager
|
|
SQL*Plus: Release 11.2.0.2.0 Production on Tue May 2 12:39:31 2017
|
|
Copyright (c) 1982, 2011, Oracle. All rights reserved.
|
|
|
Connected to:
|
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
|
|
SQL> SELECT LPAD('a',10) FROM DUAL;
|
|
LPAD('A',1
|
----------
|
a
|
Under terms of this task will also make the third parameter optional.
|