1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
JulijaS [17]
3 years ago
15

Create a statement trigger called "bt_maj_adv_trigger" that would be work with both advisor as well as major table. If a record

is inserted, deleted or updated in either of the table, the system will insert the user name, table name, date, and the dml command executed on the table. To insert this information, create an appropriate "log_maj_adv" table first before you create the trigger
Computers and Technology
2 answers:
denis23 [38]3 years ago
5 0

Answer:

Create or replace trigger at_advisor

after delete or insert or update on advisor

for each row

Begin

  if inserting

then

  insert into

     log_maj_adv

  values

     (

        user, :new.adv_code, sysdate, 'insert'

     )

;

elsif deleting

then

  insert into

     log_maj_adv

  values

     (

        user, :new.adv_code, sysdate, 'delete'

     )

;

else

  insert into

     log_maj_adv

  values

     (

        user, :new.adv_code, sysdate, 'update'

     )

;

end if;

End;

Explanation:

as per above answer.

Gnom [1K]3 years ago
4 0

Answers ehowhejej

Explanation:

You might be interested in
Write a java program that accepts the ingredients for a recipe in cups and converts to ounces
Tanzania [10]

Answer:

Explanation:

public static int cupsToOunces (int cups) {

   

       int ounces = cups * 8;

       return ounces;

       

   }

This is a very simple Java method that takes in the number of cups in the recipe as a parameter, converts it to ounces, and then returns the number of ounces. It is very simple since 1 cup is equal to 8 ounces, therefore it simply takes the cups and multiplies it by 8 and saves that value in an int variable called ounces.

6 0
3 years ago
What is the process called when programmers look for and fix errors in code? Analysis Debug Document Error check
Sunny_sXe [5.5K]
It’s Debug. definition: “identify and remove errors from (computer hardware or software)”.
4 0
3 years ago
Read 2 more answers
How do you set up nordvpn with spectrum?
Setler [38]

Answer:

simple

Explanation:

use nordvpn with discount code: Chonchode

7 0
3 years ago
What is most likely to happen to the purchasing power of money over time?
natima [27]

Answer:

A

Explanation:

6 0
2 years ago
What is the default junk email protection in Outlook 2016?
Shtirlitz [24]
The answer to ur question is D
4 0
3 years ago
Read 2 more answers
Other questions:
  • In 1-2 paragraphs discuss the three main purposes of design and provide examples for each. Also explain how a design might serve
    15·1 answer
  • When choosing a new computer to buy, you need to be aware of what operating _____ a0 it uses.
    6·1 answer
  • Many people object to increased cybersecurity because _____.
    12·2 answers
  • What was the first fully computer animated feature film?
    13·1 answer
  • When an interrogator speaks highly about how a crime was committed, hoping to get the suspect to brag about his or her involveme
    7·2 answers
  • In 1971, Intel created and marketed the first microprocessor chip, called the Intel 4004. What was significant about this invent
    7·1 answer
  • Which of the following is not an element of the modified block style?
    7·2 answers
  • In the code snippet, what is the “win” part called in programming?
    12·1 answer
  • A town government is designing a new bus system. The planners are deciding where to put the different bus stops. They want to pi
    6·2 answers
  • I WILL MARK BRAINLEST FOR THIS!!!
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!