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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started