Question: /* Insert the data into the COURSE table */ INSERT INTO COURSE VALUES('ACCT-211','Accounting I',3); INSERT INTO COURSE VALUES('ACCT-212','Accounting II',3); INSERT INTO COURSE VALUES('CIS-220','Intro to Microcomputing',3);

/* Insert the data into the COURSE table */ INSERT INTO COURSE VALUES('ACCT-211','Accounting I',3); INSERT INTO COURSE VALUES('ACCT-212','Accounting II',3); INSERT INTO COURSE VALUES('CIS-220','Intro to Microcomputing',3); INSERT INTO COURSE VALUES('CIS-420','Database Design and Implementation',4);

gives me error in oracle:

ORA-00001: unique constraint (SQL_YCCNBIDFWHMDBRHQIHQGKOLRZ.SYS_C0052064000) violated ORA-06512: at "SYS.DBMS_SQL", line 1721 ORA-00001: unique constraint (SQL_YCCNBIDFWHMDBRHQIHQGKOLRZ.SYS_C0052064000) violated ORA-06512: at "SYS.DBMS_SQL", line 1721 ORA-00001: unique constraint (SQL_YCCNBIDFWHMDBRHQIHQGKOLRZ.SYS_C0052064000) violated ORA-06512: at "SYS.DBMS_SQL", line 1721 ORA-00001: unique constraint (SQL_YCCNBIDFWHMDBRHQIHQGKOLRZ.SYS_C0052064000) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

How do I fix?

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!

Need help with section #2 towards the bottom. (REM INSERT DATA INTO TABLES (#2)) CREATE TABLE COURSE ( CRS_CODE VARCHAR(8) NOT NULL, CRS_DESCRIPTION VARCHAR(35) NOT NULL, CRS_CREDIT INTEGER DEFAULT 4...

Need help with these SQL, did some of it. CREATE TABLE COURSE ( CRS_CODE VARCHAR(8) NOT NULL, CRS_DESCRIPTION VARCHAR(35) NOT NULL, CRS_CREDIT INTEGER DEFAULT 4 NOT NULL CHECK(CRS_CREDIT IN...

SQL CODE (did the rest need help with these portions): REM insert data into the COURSE table (first record given) INSERT INTO COURSE VALUES('ACCT-211', 'Accounting I', 3); INSERT INTO COURSE...

Using TinyCollege database, write the sql queries to answer each of the following questions. Your answer should consist of the SQL query and also the result of the query in a table form. Show all...

Need help with these portions of code: REM insert data into the CLASS table (first record given) INSERT INTO CLASS VALUES(10012,'ACCT-211',1,'MWF 8:00-8:50 a.m.','BUS311'); REM insert data into the...

Need help with these portions of SQL: REM insert data into the CLASS table (first record given) INSERT INTO CLASS VALUES(10012,'ACCT-211',1,'MWF 8:00-8:50 a.m.','BUS311'); REM insert data into the...

/*Please answer the Queries and display the code and output.*/ This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical...

Please answer each query and display the output Query 1: Create a new table, FACULTY5, and populate it with faculties in department ID 5, using an existing table. Use faculty ID, name, and salary...

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

Find the instructor who has taught the most number of distinct courses. Dont use ORDER BY and LIMIT in your solution. Database to query from: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Table...

3, 12, 15, 18, 16, 15, 22, 30, 25, 4, 6, 9 (95%) Find the confidence interval of the median, indicated in parentheses, for the set of data.

We want you to analyze your topic Write a full page double spaced 12 point Times New Roman font topic analysis focused on these following questions What is your topic What is your preliminary...

During the start of the financial crisis, the dollar sharply Blank _ _ _ _ _ _ against most other currencies as global investors sought a safe haven investment in Blank _ _ _ _ _ _ . Multiple choice...

3. This activity will need to be role-played with a friend or family member. Using oral communication skills. verbally provide an overview of a finished document with the aim of getting it approved....

How do Dimensional Database Models differ from Relational Models?

What type of processing do Relational Databases support?

Describe several aggregation operators.