LEVEL, LAPD
lpad ('string', n [, 'string_pad') rpad ('string', n [, 'string_pad') string is left padded to length n with string_pad. If string_pad is ommited, a space will be used as default rpad is similar, but pads right instead of left. SQL> select LPAD('L', 10, 'a') LPAD, RPAD('R', 10, 'b') RPAD from dual; LPAD RPAD ---------- ---------- aaaaaaaaaL Rbbbbbbbbb SQL> The Oracle DUAL table dual is a table w..
더보기