At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all products associated with a cancelled order and that updates the ORDERPLACED column of the BB_BASKET table to zero, reflecting that the order was not completed. Create a trigger named BB_ORDERCANCEL_TRG to accomplish this task by considering the following items:

Posted Date: 7/11/2014 8:10:51 PM | Location : Canada

Ask an Expert

Related Discussions:- triggers, Assignment Help, Ask Question on triggers, Get Answer, Expert's Help, triggers Discussions

Write discussion on triggers
Your posts are moderated

Write your message here..

Related Questions

Unnest operator in sql, UNNEST operator in SQL The inverse operator of... UNNEST operator in SQL The inverse operator of GROUP is UNGROUP. SQL has an operator, UNNEST, that can be used for similar purposes, but its method of invocation is somewhat p

Information hiding in pl/sql, Information Hiding   With the informatio... Information Hiding   With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding

Existential quantification - sql, Existential Quantification - SQL Ex... Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Defining records, Defining and Declaring Records To create records, yo... Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Assigning and comparing collections, Assigning and Comparing Collections ... Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Effects of null for table expression, Effects of NULL for Table Expression ... Effects of NULL for Table Expression Here's an important distinction between expressions denoting tables and expressions denoting multisets of rows: a table expression cannot

Effects of null for unique specification - sql, Effects of NULL for UNIQUE ... Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

Cause of indeterminacy in sql, Cause of Indeterminacy in SQL One root ... Cause of Indeterminacy in SQL One root cause of indeterminacy in SQL lies in its implementation of comparison for equality. For certain system-defined types it is possible for

Triggers, At times, customers make mistakes in submitting their orders and ... At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Rowid - sql pseudocolumns, ROWID The ROWID returns the rowid (binary a... ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il