Question: a) Convert the following for-cursor into: open, fetch, close one: DECLARE Cursor ci is select table_name from user_tables: BEGIN FOR tables IN c1 LOOP DBMS_OUT.PUT_LINE

a) Convert the following for-cursor into: open, fetch, close one: DECLARE Cursor ci is select table_name from user_tables: BEGIN FOR tables IN c1 LOOP DBMS_OUT.PUT_LINE (tables.table_name); END LOOP: END: b) Create a trigger so that when user tries to update category table, new value won't take effect and old data will remain in the database. c) Create a function to return if a particular film has more than 10 actors in it or not Film Film Actor SMALLINT SMALLINT PF actor_id PF timid P * Vid Language Planguage id SMALLINT name CHAR (20) title description release year Flanguage_id F original language_id rental duration rental rate SMALLINT VARCHAR2 (255) VARCHAR2 (255) SMALLINT SMALLINT SMALLINT SMALLINT NUMBER (42) SMALLINT NUMBER (5.2) VARCHAR2 (6) VARCHAR2 (255) TIMESTAMP length replacement cost rating special features last update Film Category PF im id SMALLINT SPF category.id SMALLINT Actor P. actor id SMALLINT first name VARCHAR2 (45) last name VARCHAR2 (45) Fnationality CHAR (2) Country P countryd SMALLINT U short code CHAR (2) name VARCHAR2 (25) Category PCategory ld SMALLINT "name VARCHAR2 (25) parent.cat SMALLINT

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!

Using the film database you have, answer the following queries in your schema then write them down in this paper. Question one: a) Select the total rental_rate for films grouped by their categories....

Using the film database you have, answer the following queries in your schema then write them down in this paper. a) Convert the following for-cursor into: open, fetch, close one: DECLARE Cursor c1...

Convert the following for-cursor into: open, fetch, close one: DECLARE Cursor c1 is select table_name from user_tables; BEGIN FOR tables IN c1 LOOP DBMS_OUT.PUT_LINE(tables.table_name); END LOOP; END;

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

What does the following code do ? Declare cursor c1 is select salary from manager; s number(10); n number(10):=0; begin open c1; loop fetch c1 into s ; exit when c1%not found; n:=n+ s ; end loop;...

Evaluate the following PL/SQL block: DECLARE CURSOR c_1 IS SELECT col_1, col_3 FROM tab1 ORDER BY c1; v_rec c_1%ROWTYPE; BEGIN OPEN c_1; LOOP FETCH c_1 INTO v_rec; EXIT WHEN v_rec.col_1 >= 100 OR...

Following PL/SQL code implements a cursor and displays the first 3 highest students grades in course seqid '00001' DECLARE CURSOR c1 IS SELECT sname, grade FROM Student s JOIN Taken t ON s.sid=t.sid...

What does the following code do ? Declare cursor c1 is select salary from manager; s number(10); n number(10):=0; begin open c1; loop fetch c1 into s ; exit when c1%not found; n:=n+ s ; end loop;...

On June 1, 2008, Brooks Dodd established an interior decorating business, Coordinated Designs. During the month, Brooks completed the following transactions related to the business: June 1. Brooks...

Robin Company made the following transactions: 1. January 15, 2020, purchased equipment for $46,000. Robin Company pays sales taxes of $3,000, installation and testing of $6,000 insurance during...

A q , B C D E F G H 1 Computing Alternative Cash Distributions to Partners Bracken, Louden, and Menser; ' who share profits and losses in a ratio of 4 : 3 : 3 , respectively, are partners in a home 2...

give rationale why mann whitney test best statistical test for this case : Do significant differences exist between husbands and wives regarding holiday depression? There is an ordinal measure of...

A What are the benefits of having an audio file available? Why is podcasting more effective than old-fashioned analog recordings? 2 Are downloaded presentations as effective as live ones? Can they...

What techniques can you use to look at a subject and find its relevance to you or to your audience? How can these tactics help you create more interesting informative speeches?

A Kotbs approach to informing women about sex is a far cry from the often lighthearted and humorous approaches used by talk show hosts in the United States. How might her approach to informative...