Hi
I'm new to db2 and i need to
1. can someone help me in understanding what the below datatype expression.
2. Use equivalent datatype in ORACLE

If some one can help me in getting equivalent datatypes in oracle it would be great help.

a. Decimal( 0, 1, 0 )
b. DIGITS(YEAR( DW_DATE ))
c. DATE( calnder_date + 719892)


Thanks in advance,
Kanth.

not data type, they are functions

a>decimal (number,precision,scale)
b> Converts an integer or decimal value into a character string with leading zeros. Both the sign
indicator and the decimal point are lost in the translation.
c> date of (calnder_date + no of days )

Do someone know equivalent function in oracle.

This redbook should answer this question and more ..

http://publib-b.boulder.ibm.com/Redb...7048.html?Open

sathyaram

document didn't help.

You should probably ask your question in an Oracle group.