Software

Ask something
Question Locked

I need help with decimal places please.

0 helpful
7 replies

by alex789

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all and thanks in advance,

I have the following table but when I insert some values, the program displays an error message it says "(101,'Smith',30000)
ERROR at line 2: ORA-01438: value larger than specified precision allows for this column"

Here are the table and insert value:

CREATE TABLE physican(
phys_Ref_no NUMBER(3) NOT NULL,
phys_name VARCHAR2(6),
phys_salary NUMBER(5,2),
PRIMARY KEY (phys_Ref_no));

INSERT INTO physician VALUES
(101,'Smith',30000);

Help me please.

7 replies

by boxfiddler Hot topic

1) On the Tools menu, click Options, and then click the Calculation tab.
Under Workbook options, click 'Select the Precision as Displayed' check box.

2) Also, given that it appears there is text in this cell in addition to numbers, try formatting the cells in the column/row (whichever it is that will contain this data format) as General or Text.

Specified precision is related to calculations in some manner. Whether you are calculating or not, often a cell entry that appears to Excel to break a calculation rule can prove problematic, hence ensuring that cell format is general or text. These formats are not used in calculations.

by boxfiddler Hot topic

Missed that primary key reference entirely and assumed Excel. Thanks for waking me up.

by alex789

Thank you very much, Your knowledgeable answer and kindly help really means a lot to me. I greatly appreciated it.

by boxfiddler Hot topic

add to that the educational bureaucracy nightmare and it's a wonder I didn't answer with help using Word!

This discussion is closed to new replies.