Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Error at line 2/33: ORA-00913: too many values ORA-06512: at SYS.WWV_DBMS_SQL_APEX_220200, line 828 ORA-06512: at SYS.DBMS_SYS_SQL, line 1658 ORA-06512: at SYS.WWV_DBMS_SQL_APEX_220200, line 813 ORA-06512:

image

Error at line 2/33: ORA-00913: too many values ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 828 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 813 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2046 1. INSERT ALL 2. 3. WHEN salary > 20000 THEN INTO new_specialsal (employeeid, salary) WHEN 1=1 THEN INTO new_salhistory (employeeid, hiredate, salary) WHEN 1=1 THEN INTO new_mgrhistory (employeeid, managerid, salary) 4.

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_2

Step: 3

blur-text-image_3

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

Advanced Accounting

Authors: Gail Fayerman

1st Canadian Edition

9781118774113, 1118774116, 111803791X, 978-1118037911

More Books

Students also viewed these Algorithms questions