What is a trigger, and what is its purpose? Give an example.
Answer to relevant QuestionsWhat is a stored procedure, and why is it particularly useful? Give an example.What Oracle function should you use to calculate the number of days between the current date and January 25, 1999?Modify the CUSTOMER table to included two new attributes: CUST_DOB and CUST_AGE. Customer 1000 was born on March 15, 1979, and customer 1001 was born on December 22, 1988.Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by ...Create a stored procedure named prc_return_video enter data about the return of videos that had been rented. The procedure should satisfy the following requirements.a. The video number will be provided as a parameter.b. ...
Post your question