Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL Question Bookings should be archived after 2 years. Create the ARCHIVED_BOOKING table which will have the same columns as the BOOKING table and additionally
SQL Question
Bookings should be archived after 2 years. Create the ARCHIVED_BOOKING table which will have the same columns as the BOOKING table and additionally a column called ARCHIVED_DATE. Create a stored procedure to archive bookings older than 2 years (based on DATE_TO and SYSDATE). Add the old bookings to the ARCHIVED_BOOKING table and remove the old bookings from the BOOKING table.
Submit
Create statement for the ARCHIVED_BOOKING table
Listing of the Stored Procedure
Test demonstrating the execution of the archived procedure
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started