Question: Two new columns must be added to the ACCTMANAGER table: one to indicate the commission classification assigned to each employee and another to contain each

Two new columns must be added to the ACCTMANAGER table: one to indicate the commission classification assigned to each employee and another to contain each employees benefits code. The commission classification column should be able to store integers up to a maximum value of 99 and be named Comm_id. The value of the Comm_id column should be set to a value of 10 automatically if no value is provided when a row is added. The benefits code column should also accommodate integer values up to a maximum of 99 and be named Ben_id

this is what i tried doing this but i keep getting an error.

ALTER TABLE acctmanager

add(commission_IDnumber(99) default 10,

Benefit_Id number (3));

heres the error

error report

OEA-01727: numeric precision specifier is out of range (1 to 38)

01721. 00000 - "numeric precision specifer is out of range (1 to 38)

* cause:

*Action:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!