Integer to Number 1

[sivatcs]

I have a table in Teradata A, column abc integer.

I wan't to load the teradata data into a oracle table B, column abc number.

Datatype width is not specified in teradata, so what width can i give for the number column.

While unloading the data from Teradata into a file if i give a query as

Select abc (format '9(10)') from A.

How should i write the query for formatting the column.

 

[BillDHS]

I am assuming you used an ODBC connection for your select statement which won't apply a format statement. CAST to character after format

Select CAST((abc (format '9(10)')) as CHAR(10)) from A

 

[al1x24]

!!! Be carefull. Don't forget the sign.

INTEGER is a signed type, with stores values between -2147483648 and 2147483647

So, if you cast to format '9(10)', the sign could be lost.