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

CURSOR, #quesWrite a cursor to open an employee database and fetch the empl... #quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Implicit cursor attributes, Implicit Cursor Attributes The Implicit cur... Implicit Cursor Attributes The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribu

Literals in pl/sql, Literals A literal is an explicit numeric, string... Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Positional notation, Positional Notation The first procedure call uses... Positional Notation The first procedure call uses the positional notation. The PL/SQL compiler relates the first actual parameter, account, with the first proper parameter, ac

Keyword and parameter description - delete statement, Keyword and Parameter... Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Assignment statement in pl sql, Assignment Statement: The assignment s... Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

User-defined exceptions, User-Defined Exceptions The PL/SQL defines the... User-Defined Exceptions The PL/SQL defines the exceptions of your own. Dissimilar to the predefined exceptions, the user-defined exceptions should be declared and should be rai

Using a host variable, Using a Host Variable You can declare the curso... Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Keyword and parameter description - if statement, Keyword and Parameter Des... Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

Theory of biogenesis, THEORY OF BIOGENESIS - This theory explains th... THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or