Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

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

Step: 3

blur-text-image

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

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions