Page 1 of 1
importance of Display column in oracle stage
Posted: Tue Dec 05, 2006 3:10 am
by parvathi
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
Posted: Tue Dec 05, 2006 3:44 am
by ray.wurlod
What data type, what precision?
For example, NUMBER(22,2) needs one place for the decimal place and one for the sign. Total 24.
Posted: Tue Dec 05, 2006 4:02 am
by parvathi
The datatype is number 22 in oracle
but i didnot mention the precision
Posted: Tue Dec 05, 2006 5:21 am
by ray.wurlod
In that case precision is 0.
"-2837213623238928331187." contains 24 characters.
Posted: Tue Dec 05, 2006 5:55 am
by parvathi
THANKS
Re: importance of Display column in oracle stage
Posted: Tue Dec 05, 2006 8:40 am
by chulett
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.
Posted: Tue Dec 05, 2006 6:50 pm
by ray.wurlod
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.
Posted: Tue Dec 05, 2006 6:51 pm
by chulett
Not in the
Oracle stage, which was the specific question I was answering.
