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 ?
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 ?