Explain the relationship between these pieces of code CREATE SEQUENCE Customers_Sequence; _______________________________________________________________________ CREATE TRIGGER Customers_Sequence_Trigger BEFORE INSERT ON Customers FOR EACH ROW WHEN (new.CustomerID IS NULL) BEGIN SELECT Customers_Sequence.NEXTVAL INTO :new.CustomerID FROM dual; END; ________ CREATE TABLE Customers ( CustomerID int , CustFirstName varchar (25) NULL , CustLastName varchar (25) NULL , CustStreetAddress varchar (50) NULL , CustCity varchar (30) NULL , CustState varchar (2) NULL , CustZipCode varchar (10) NULL , CustAreaCode smallint DEFAULT 0 NULL , CustPhoneNumber varchar (8) NULL ); _ INSERT INTO Customers (CustomerID, CustFirstName, CustLastName, CustStreetAddress, CustCity, CustState, CustZipCode, CustAreaCode, CustPhoneNumber) VALUES (1001, 'Suzanne', 'Viescas', '15127 NE 24th, #383', 'Redmond', 'WA', '98052', 425, '555-2686'); INSERT INTO Customers (CustomerID, CustFirstName, CustLastName, CustStreetAddress, CustCity, CustState, CustZipCode, CustAreaCode, CustPhoneNumber) VALUES (Null, 'Williams', 'Thompsons', '1254 Spring River Drive', 'Duvall', 'WA', '98019', 427, '566-2681');

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Related questions

Concept explainers

Question

Explain the relationship between these pieces of code

CREATE SEQUENCE Customers_Sequence;

_______________________________________________________________________

CREATE TRIGGER Customers_Sequence_Trigger

BEFORE INSERT ON Customers

FOR EACH ROW

WHEN (new.CustomerID IS NULL)

BEGIN

SELECT Customers_Sequence.NEXTVAL

INTO :new.CustomerID

FROM dual;

END;

________________________________________________________________________

CREATE TABLE Customers (

CustomerID int ,

CustFirstName varchar (25) NULL ,

CustLastName varchar (25) NULL ,

CustStreetAddress varchar (50) NULL ,

CustCity varchar (30) NULL ,

CustState varchar (2) NULL ,

CustZipCode varchar (10) NULL ,

CustAreaCode smallint DEFAULT 0 NULL ,

CustPhoneNumber varchar (8) NULL

);

_________________________________________________________________

INSERT INTO Customers

(CustomerID, CustFirstName, CustLastName, CustStreetAddress,

CustCity, CustState, CustZipCode, CustAreaCode,

CustPhoneNumber)

VALUES (1001, 'Suzanne', 'Viescas', '15127 NE 24th, #383',

'Redmond', 'WA', '98052', 425, '555-2686');

INSERT INTO Customers

(CustomerID, CustFirstName, CustLastName, CustStreetAddress,

CustCity, CustState, CustZipCode, CustAreaCode,

CustPhoneNumber)

VALUES (Null, 'Williams', 'Thompsons', '1254 Spring River Drive',

'Duvall', 'WA', '98019', 427, '566-2681');

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.