I am working on creating tables with data in oracle sql I have created the first table and created my second table I started to add the data line by line The issue is that there is data that is the same in several different lines of the table It will only let me add information in once when I need it listed for several Below is the chart I am creating (RECIPE) RECIPE Table Ice cream ID Ingredient ID Quantity used pint 101 1000 30 540 1000 75 545 1000 55 101 1100 40 201 1100 45 407 1200 25 101 1200 20 201 1200 45 311 1200 40 321 1300 35 101 1300 80 540 1300 50 545 1400 15 405 1400 10 406 1400 27 5 201 1500 10 540 1500 5 5 211 1500 60 101 1700 5 520 1700 10 I used coding INSERT INTO RECIPE VALUES ('101', '1000', '30') for the first line When I went to do the second line the same way it caused an error due to '1000' already being in the first line How do I bypass this I am getting an ORA 00001 Unique Constraint

The Answer is in the image, click to view ...

Question: I am working on creating tables with data in oracle sql. I have created the first table and created my second table. I started to

I am working on creating tables with data in oracle sql. I have created the first table and created my second table. I started to add the data line by line. The issue is that there is data that is the same in several different lines of the table. It will only let me add information in once when I need it listed for several. Below is the chart I am creating (RECIPE)

RECIPE Table

Ice_cream_ID	Ingredient_ID	Quantity used/pint
101	1000	30
540	1000	75
545	1000	55
101	1100	40
201	1100	45
407	1200	25
101	1200	20
201	1200	45
311	1200	40
321	1300	35
101	1300	80
540	1300	50
545	1400	15
405	1400	10
406	1400	27.5
201	1500	10
540	1500	5.5
211	1500	60
101	1700	5
520	1700	10

I used coding INSERT INTO RECIPE VALUES ('101', '1000', '30'); for the first line. When I went to do the second line the same way it caused an error due to '1000' already being in the first line. How do I bypass this? I am getting an ORA-00001 Unique Constraint

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!

1. Given a database state of the Windsor Music Records database shown in Figure 1.1, with schema shown in Figure 1.2 Total for que 1 is 15 marks) Fig 1.1: An Example Database State of Windsor Music...

1) List all the referential integrity constraints that should hold on the database schema? (2.5 marks) 2) Write appropriate SQL DDL statements to define the database with the integrity constraints...

/* IVY TECH COMMUNITY COLLEGE DBMS130 M02 Hands-On Lab Assignment Constructing the Database */ /* (5 points) After completing your SQL below, upload your Script and Run it until all errors are...

purpose of this assignment is to provide learners with hands-on experience in designing, creating, and managing a relational database while analyzing real-world data related to prenatal care...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

this is how the screenshoot should look like please my name should be writing in the screen capture here is my name patrick desc vendor; --Amritpreet, 0.1 CREATE TABLE CUST2 (CUST_ID, NAME, ADDRESS,...

create a new database called "Assignment1_firstname_lastname"- replace firstname_lastname with your first name and last name. 2. After you have created your database successfully then switch to it...

Health Care Options, Inc. (HCO) is a home-health care facility located in the heart of the Blue Ridge Mountains. It supports local residents within a 50-mile radius by providing home health care...

Phase 1 ERD In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules...

1)How can cards, such as multicards, provide you with cleaner visuals? Select an answer: They remove irrelevant data and display the most relevant data. They provide summary data and an easier way of...

Which of the following is not true about a high-context culture: A. lawyers are less important B. negotiations are lengthy C.people maintain a bubble of private space D. competitive bidding is less...

Capri Design specializes in imported clothing. During May, Capri completed a series of transactions. For each of the following items, give an example of a transaction that has the described effect on...

Below is the common equity section ( in millions ) of ABC Company's last two year - end balance sheets: \ table [ [ , 2 0 2 0 ? , 2 0 1 9 ?

Question 20 Suppose that you have estimated the Fama-French three-factor and four-factor models for three different stocks: BCD, FGH, and JKL. Specifically, using return data from 2005 to 2009, the...

5 There is also a need to think from different perspectives and at the different multifunctional, corporate and subsidiary levels. This requires managers to be open-minded, flexible and adaptable.

Whilst delayering and downsizing may be aspects of organizing which are contingent on responding to the needs of economic downturn, shareholders interests and efficiency, they may be less effective...

3 What specific practices, such as autonomous and cross-functional teams, and principles, such as empowerment, are best suited to which cultural contexts? How are these practices (with their...