Reference no: EM131210612
Module Triggers
Module Overview
- In this module you will learn how to write PL/SQL and T-SQL triggers
Objectives
After completing this module you will be able:
- to develop, test and debug Oracle PL/SQL triggers
- to develop, test and debug MS SQL Server T-SQL triggers
Lab
You have to run every script in this module and understand each line of code before you can start this lab assignment.
Q1: Refine the Example 4 from PL/SQL in way so that updating does not change value of ID column. Provide a screenshot of your trigger with compilation results.
Test the trigger with the following queries with expect the following result.
Q2: You would revise a trigger created in Example 2 of T-SQL. Frist, drop the transTrigger then redefine just like before, except when adding balance in account, 10% interest would be added up on the old balance. See formula below:
balance=balance*1.1 + @amount
You need to provide the code of your trigger, with screenshot of compilation.
To test you need to issue the following command:
You can compare your results before and after running the trigger:
Before
You will need to make some changes to generated code before you can run it in Oracle.
Feedback:
Difficulty (-2 - too easy ... 0 - just right ... 2 - too hard)
Interest level (-2 - low interest ... 0 - just right ... 2 - high interest)
Time to complete (min):
Suggestion to improve (if any):
Attachment:- Procedural_SQL_PartIII.rar
|
Company selection and initial research
: Assignment: Inventory Analysis and Final Project: Company Selection and Initial Research Part One: Inventory Analysis
|
|
Can tom prevail in a breach of contract action
: Legal Environment and Corporate Governance Can Tom prevail in a breach of contract action against Ritz? Critically discuss using case law to illustrate your points - Is the assignment by Ritz to CreditCo effective? Critically discuss using case law t..
|
|
Global currency markets
: How does the Chinese government limit the use of the Chinese currency, the RMB, on the global currency markets?
|
|
Rate of return on investment
: This firm paid a dividend of $13.5 cents per share during the year. What was the return ($) to holding Omega's shares during 2015? What is the rate of return on investment?
|
|
Compare results before and after running the trigger
: You can compare your results before and after running the trigger - You will need to make some changes to generated code before you can run it in Oracle.
|
|
Develop a new textbook
: A publishing company is trying to decide if it pays to develop a new textbook. The new textbook will be completed and ready for sale in 3 years.
|
|
What should be done if there are no other resources
: What should be done if there are no other resources? Should we consider the implications of this type of resource over the benefit? Please share your thoughts on these issues.
|
|
Draw a production possibilities curve to graphically show
: Draw and use a production possibilities curve to graphically show and verbally explain to the subcommittee members the opportunity cost at a point in time of expanding any one of the programs.
|
|
What would it cost in dollars to purchase
: What would you receive in dollars if you sold PZ 5 million at the spot rate? - What would it cost in dollars to purchase PZ 20 million forward three months. When would you make payment?
|