importance of Display column in oracle stage

parvathi · Post by **parvathi** » Tue Dec 05, 2006 3:10 am

Hi all

while importing the meta data of the table in an oracle stage
the length of my column is 22 and under display it is shown as 24.
what actually display column will do and its importance and what is dataelement

ray.wurlod · Post by **ray.wurlod** » Tue Dec 05, 2006 3:44 am

What data type, what precision?
For example, NUMBER(22,2) needs one place for the decimal place and one for the sign. Total 24.

parvathi · Post by **parvathi** » Tue Dec 05, 2006 4:02 am

The datatype is number 22 in oracle
but i didnot mention the precision

ray.wurlod · Post by **ray.wurlod** » Tue Dec 05, 2006 5:21 am

In that case precision is 0.
"-2837213623238928331187." contains 24 characters.

parvathi · Post by **parvathi** » Tue Dec 05, 2006 5:55 am

THANKS

chulett · Post by **chulett** » Tue Dec 05, 2006 8:40 am

parvathi wrote:what actually display column will do and its importance

To actually answer your question - It controls the initial width of the column in the data grid when you View Data... nothing more, nothing less.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 05, 2006 6:50 pm

But wait! There's more!

It (Display Width) also controls the column width if you write to (or read from) a fixed-width sequential file.

chulett · Post by **chulett** » Tue Dec 05, 2006 6:51 pm

Not in the Oracle stage, which was the specific question I was answering.

DSXchange

importance of Display column in oracle stage

importance of Display column in oracle stage

Re: importance of Display column in oracle stage