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 employee’s 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:

Answer rating: 100% (QA)

Dear Student As per the requirement submitted above kindly find the below so... View the full answer