Create a trigger that will prefix the values of item category with ‘dev-‘ when a new row ins inserted. For example if the inserted category is ‘rdf’ then then the value should become ‘devrdf’. Below is the item table CREATE TABLE Item (ItemID NUMBER PRIMARY KEY, category VARCHAR2(12)); Write in SQL

Create a trigger that will prefix the values of item category with ‘dev-‘ when a new row ins inserted. For example if the inserted category is ‘rdf’ then then the value should become ‘devrdf’. Below is the item table CREATE TABLE Item (ItemID NUMBER PRIMARY KEY, category VARCHAR2(12)); Write in SQL

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 4MC: Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM...

See similar textbooks

Similar questions

Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)
Create a trigger named InstructorInsertSalaryTR that fires when a new row is added to the Instructors table. Throw an error when multiple rows are inserted. When there is only one row inserted, validate that the AnnualSalary value is positive (strictly greater than zero) and less than or equal to 120000. Throw an error with appropriate message if the salary value is negative or too big. Also, if the salary value is between 0 and 10000, assume that there was a mistake of entering monthly salary instead of annual salary, and multiply the salary value by 12. For example, if the new value of the salary is 5000, it should be changed to 60000. No need to validate any other data from the inserted row. Test the trigger with appropriate INSERT statements. There should be four cases: 1) with negative salary, 2) with positive salary <= 10000, 3) with salary greater that 10000 and less than or equal to 120000, and 4) with salary > 120000.
CREATE TABLE test( test_id INTEGER PRIMARY KEY, test_name varchar2 (255) ,t_date DATE, t_result varchar2(255));ALTER TABLE test ADD (t_time varchar2(1));INSERT INTO test values ('5454','corona','monday','11:15PM','positive'); (6567,'corona','sunday','10:50AM','negative');
What is the most efficient way to write a trigger that updates a large number of rows? Specify "for each statement" Specify "for each row" Specify "for each table" Specify "referencing new row"
Write a trigger to update the CUST_BALANCE when an invoice is deleted. Name the trigger trg_updatecustbalance2. (You should delete INV_NUM 9006 from INV_MYSQL to ensure your code is correct.)
Create table “Cleaner” (cNo varchar2(5), cName varchar2(20), cSalary number(6,2), dNo varchar2(5)). Write a table level trigger which can tell how the restriction on ‘cSalary’ is violated. Whenever the value of ‘cSalary’ is beyond the valid range (0 – 5000), the trigger will generate an error message informing user whether it is greater than 5000 or a negative number
In MySQL please: The Question: Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Which of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.
Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.