String functions returning wrong size

fbnunes

Member
Hi

This statement:

"select codigo,
lpad(nomefantasia,10,'-') nome,
contacorrente
from bancos"

In Oracle 9, returns:

CODIGO NOME CONTACORRENTE
------ ---------- ----------------
3 -Amazonia
4 ----B n b 405165
1 -B Brasil 150.079-1
1 --B Brasil 1500791

But, in Oracle 10...

CODIGO NOME CONTACORRENTE
------ -------------------------------------------------------------------------------- ----------------
3 -Amazonia
4 ----B n b 405165
1 -B Brasil 150.079-1
1 --B Brasil 1500791
...

The size of the field "Nome" is informed as 4000.
In SQL*Plus is the same thing.

How to get the same result as in Oracle 9 ?
 
Back
Top