Question: 7. Now, you will create a trigger to run after INSERTS and UPDATES on the customers table to log customers with birthdates showing that they

7. Now, you will create a trigger to run after INSERTS and UPDATES on the customers table to log customers with birthdates showing that they are not yet 18 years of age. Firstly, review the "Tutorial: Creating a Trigger that Logs Table Changes" example at https://docs.oracle.com/database/121/TDDDG/tdddg_triggers.htm#TDDDG50000 7.1. Here are the details for your trigger: 7.1.1. Use the construct "trunc(months_between(sysdate, birthdate)/12)" to determine the age in years. If they are currently under 18, put an entry in the "UNDER18_CUSTOMERS" table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Conduct an internet search to find an organization that lists its mission and vision statement on its website. What do the mission and vision statements communicate? How might the organization use...

Lab 3 Creating Profiles, Users and Roles Overview: In this lab, you will demonstrate you are comfortable creating users, profiles and roles. You must connect to the provided AWS Oracle RDS...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

1 Budgeted Income Statement 3 Sales 4 Cost of Goods Sold 5 Gross Profit 6 Selling Expenses 7 Administrative Expenses 8 Net Operating Income 9 10 Goal Seek 1 3 # of Unit Sales necessary to have...

please show me the formula or how you get the answers please go down and take it look...i have taken new photo that is clear Accounting 365 Flex Budget Project Instruction BEFORE YOU NON HEAD CLOSELY...

I need some assistance with this worksheet Please and Thank you. I JUST NEED THE ANSWERS FOR THEM THANK YOU THEY ARE 5 SECTIONS WITH A TOTAL OF 15 QUESTIONS Question 1 of 15 1. A small consulting...

Please complete the attached worksheet thank you and highlight the answer in yellow see attachment Question 1 of 15 1. A small consulting company wants to make the switch to QuickBooks Online. All of...

I need chapters 18, 19, 20, and 21 for the workbook for Personal Finance by Madura!! Please help!!! Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX...

Yardstick Report: Comparing Clothing Retailers Web Sites You work for the Marketing Department of Urban Jungle Apparel, an ascendant specialty retailer offering clothing, accessories, and personal...

Define yield management. How does it differ from the pure strategies in production planning?

An abstract of title is recorded in the probate indeves in the county clerk's office. a condened thintary of all the invtnuments found in the tithe setich that affect a particular parcel of lind. a...

A steel manufacturer wanted to study the effect that four sizes of roller gaps, (2 cm, 4 cm, 6 cm, 8 cm), have on a steel manufacturing process with respect to the tensile strength (lbs/in2) of the...