Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started