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

Posted Date: 7/11/2014 8:07:23 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

Sql script to create and populate the tables, Create the four tables and po... Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Object types and collections - performance of application, Use Object Types... Use Object Types and Collections The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities an

Operator precedence-pl/sql expressions , Operator Precedence The operati... Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op

%type attribute - syntax, %TYPE Attribute The %TYPE attribute gives the... %TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci

Sql queries-oracle , 1- You can check attribute names from each table in D... 1- You can check attribute names from each table in DBF11 by running for example:  desc dbf11.Member;  desc dbf11.Agent;  desc dbf11.Producer; Because some attribute names in

Using bulk collect clause- bulk bind performance improvement, Using the BUL... Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

Overriding default locking, Overriding Default Locking By default, the... Overriding Default Locking By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to you

In operator-comparison operators, IN Operator The operator IN tests the ... IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Named notation, Named Notation The second procedure call uses the name... Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

Explicitly specifying the join condition - sql, Explicitly specifying the j... Explicitly specifying the join condition - SQL SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId ) Now, the key word JO