Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 5, Problem 3HOA
Save the changes permanently to the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Developers team also wants you to ensure that emails are converted to lowercase
after an update operation. Currently, new insertions are guaranteed to have lowercase
emails, but there is no such guarantee for legacy emails. Therefore, the team wants to
ensure that emails are being retained in a lowercase irrespective of any changes in the
database. Create a new TRIGGER called email_update for the USERS table that runs
before an UPDATE operation.
Task
Create a TRIGGER to run on the USERS table before any UPDATE operation.
1) Add a new row in the ORDERS table with the following data: Order# = 1021, Customer# = 1009, and Order date = July 20, 2009.
2)Modify the zip code on order 1017 to 33222.
3)Save the changes permanently to the database.
4)Add a new row in the ORDERS table with the following data: Order# = 1022, Customer# = 2000, and Order date = August 6, 2009. Describe the error raised and what caused the error.
5)Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.
6)Create a script using substitution variables that allows a user to set a new cost amount for a book based on the ISBN.
7)Execute the script and set the following values: isbn = 1059831198 and cost = $20.00.
8)Execute a command that undoes the change in Step 7.
9)Delete Order# 1005. You need to address both the master order record and the related detail records.
10)Execute a command that undoes the previous deletion.
Task 5:
The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation.
Task: Create a TRIGGER to run on the USERS table before any UPDATE operation.
(SQL Database Test): Create a TRIGGER before any UPDATE operations on the USERS table
Chapter 5 Solutions
Oracle 12c: SQL
Ch. 5 - Which command should you use to copy data from one...Ch. 5 - Which command can you use to change the existing...Ch. 5 - Which of the following is a correct statement? a....Ch. 5 - Which of the following is a valid SQL...Ch. 5 - Which of the following statements deletes all rows...Ch. 5 - What is the maximum number of records that can be...Ch. 5 - Add a new row in the ORDERS table with the...Ch. 5 - Prob. 2HOACh. 5 - Save the changes permanently to the database.
Ch. 5 - Add a new row in the ORDERS table with the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Write down 5 triggers. Triggers should be meaningful.arrow_forwardTask 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation.arrow_forwardCreate a table in your own database using the following statement. CREATE TABLE DateRange (DateID INT IDENTITY, DateValue DATE, DayOfWeek SMALLINT, Week SMALLINT, Month SMALLINT, Quarter SMALLINT, Year SMALLINT ); Write a stored procedure that accepts two parameters: A starting date The number of the consecutive dates beginning with the starting date The stored procedure then inserts data into all columns of the DateRange table according to the two provided parameters.arrow_forward
- individual characters using their 0-based index. Hint: You will need to do this for checking all the rules. However, when you access a character .arrow_forwardWrite a trigger to update the CUST_BALANCE when an invoice is deleted. Name the trigger trg_updatecustbalance2.arrow_forwardCreate a procedure to allow company employee to add new product to the database. This procedure needs only IN parameters.arrow_forward
- Please drop answer only. No need explanation.arrow_forwardThe Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0arrow_forwardWhich function can be used to add spaces to a column until it’s a specific width? (refer to the tables in the JustLee Books database.)a. TRIMLb. PADLc. LWIDTHd. none of the abovearrow_forward
- Salesforce/SOQL/Developer Please create a simple SOQL query to check the permission granted on a object with that we can get all the profile names and all active profiles with editing permission. ASAParrow_forwardThe Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0 THIS IS IN SQL FORMAT FOR CENGAGE MINDTAP, PLEASE HELP I AM STUCKarrow_forwardTopic: Databse Prompt: Transform as necessary and then write the XML elements to the appropriate tables in the database.Build SQL chunks for the following queries: What are the titles and prices of all books written by "Galos, Mike"? List the titles and the prices. What is the most recent year of publication of all books written by "O'Brien, Tim". What is the average price of all books in the "Fantasy" genre. Find the number of books in each genre. List the title and author of all books that cost less than the average price of books. XML Syntax: <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description></description> </book> <book id="bk102"> <author>Ralls, Kim</author> <title>Midnight…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY