Question: Oracle SQLPlus: Using single DML statements. Delete all the tuples from all the tables pertaining to the movie When Harry Met Sally i have tried

Oracle SQLPlus:

Using single DML statements. Delete all the tuples from all the tables pertaining to the movie When Harry Met Sally

i have tried using the following syntax but i get error: command not properly ended at line 2 "LEFT JOIN ROLE AS mr" any help is appreciated, also below is the contents of the table

DELETE FROM MOVIE LEFT JOIN ROLE AS mr ON MOVIE.Id = ROLE.m_Id LEFT JOIN STAR ON mr.s_Id = STAR.Id WHERE MOVIE.Title = 'When Harry met Sally' ;

s_id refers to talbe star

m_id refers to table movie

Oracle SQLPlus: Using single DML statements. Delete all the tuples from all

Movie title Castawa You Got Mail City of Angels budget 90000000 65000000 66000000 25000000 id rating PG-13 PG PG-13 PG-13 genre Drama Romance Horror Romance 4 When Harry Met Sall Role m id character name Chuck Noland Joe Fox Kathleen Kell Maggie Rice Cassiel Seth Sall Harr 2 2 4 2 4 Star Salary 8000000 10500000 15000000 7000000 id name Tom Hanks Meg Ryan birth year 1956 1961 1964 1948 gender Male Female Male Male Nicolas Cage 4 Billy Crystal

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!

Q:

EXTERNALLY CREATE USER username IDENTIFIED { BY password GLOBALLY AS 'external name' } [ DEFAULT TABLESPACE tablespace) [ TEMPORARY TABLESPACE { tablespace tablespace_group_name } ] [QUOTA { integer...

Q:

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...

Q:

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...

Q:

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

Q:

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Q:

Oracle Database Development Project II continues developing the Oracle database based on the Company database. Run SQL queries to test the Investment database in your Oracle account. The project...

Q:

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Q:

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Q:

iv. To remove any inserted data and destroy all created tables in the farmer database, write appropriate SQL DML and DDL statements in a text file called userid_farmerdroptable.sql to first delete...

Q:

Project 2 was a logical model of the Mom & Pop database. Step One: CREATE THE SQL DDL FOR YOUR DATABASE For your logical database model created in Project 2 , create the SQL DDL commands that will be...

Q:

A rocket body of mass M will fall out of the sky with terminal speed vT after its fuel is used up. What power output must the rocket engine produce if the rocket is to fly (a) At its terminal speed...

Q:

Ecolnvest group of companies comprises of Ecolnvest Holding Bhd (Ecolnvest) and two wholly-owned subsidiaries, Dayalnvest Sdn Bhd (Dayalnvest) and Majulnvest Sdn Bhd (Majulnvest). Ecolnvest has an...

Q:

PROBLEM 13-5. Comparing Income to Cash Flow from Operations; Ethics Alex Rembol is the CEO of Antura Corporation, a company that manufactures and sells contact lenses, lens cleaning and wetting...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

=+7 For which type of work and business purposes management, sales, control, technology transfer, business development, product

Q:

=+ Will the outsourcing and off-shoring of this type of work continue?

Q:

=+development, management development, etc. are the various types of international employees used? Why? Which is most effective?