Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Publishing With Filemaker Pro On The Web

Authors: Maria Langer

1st Edition

0201696657, 978-0201696653

More Books

Students also viewed these Databases questions