Do we need to change the sql_type in parallel?

dsuser91 · Post by **dsuser91** » Mon Dec 06, 2010 12:05 pm

Do we need to change the sql_type in parallel?

COLUMN NAME: ID
SQL_TYPE: DECIMAL
LENGTH: 14
DISPLAY: 17

O/P 555

PARALLEL:

COLUMN NAME: ID
SQL_TYPE: DECIMAL
LENGTH: 14

O/P
000000000000555.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 06, 2010 1:20 pm

No. The leading zeroes are added when the value is displayed or converted to string to show that precision and scale are being handled correctly. The value is correct.

dsuser91 · Post by **dsuser91** » Mon Dec 06, 2010 3:08 pm

ray.wurlod wrote:No. The leading zeroes are added when the value is displayed or converted to string to show that precision and scale are being handled correctly. The value is correct. ...

Thanks