Hi All,

anyone can explain me about precision n scale properties.
while extending one column in a table we will cum under
these properties.

Thanks n advance.

Answer Posted / neha

Scale is the total no of digits that can come for a
particular numeric field to the right and left of the
decimal point.
Precision is the number of digits to the right of decimal point.
Eg. for numeric field the scale is 6 and precision is 2.
Then it can accomodate:

9999.99 and 99999.9 are valid but 999.999 is invalid and
will give Data Type not found/mismatch error.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is detailed category in configuration, and its use?

555


How is siebel 7.x architecture different from siebel 6.x? How is siebel 7.x architecture different from siebel 6.x?

862


How can you resolve foreign key in eim?

562


How to Get the MultiValueFields in Workflow

1858


hi,i would like to know the what are the questions they will ask for siebel testing. i need question for only siebel testing only

1749






Explain the difference between lov and picklist??

570


Explain about the eim tables and base tables are required to your entities?

488


Explain how is siebel 7.x architecture different from siebel 6.x?

485


Explain dynamic picklist?

523


What is detail applet and association applet?

615


Explain what is all mode sort?

559


What is horizontal and vertical in siebel?

609


How to import lovs?

538


How would you import international phone numbers using eim in siebel realtime?

510


Explain the difference between an organization and division in siebel?

540