Homework Answers
DATABASE NAME WAS NOT MENTIONED HERE SO I USED AN EXAMPLE NAME "db_name" YOU CAN RENAME IT TO WHATSOEVER YOUR DATABASE NAME IS
UPDATE db_name SET Contact='Leela', Phone='800-123-4321' WHERE PUBID=5;
EXPLANATION:
UPDATE IS A WORD WHICH IS PRE-SET IN SQL WHICH HAS THE FUNCTIONALITY OF UPDATING A DATABASE RECORD. AFTER WRITING THE NAME IF TABLE YOU HAVE TO USE THE WORD SET WHICH SET THE NEW PARAMETERS OF THAT PARTICULAR DATA MEMBER META DATA. THEN AFTER SETTING WE HAVE TO USE WHERE KEYWORD WHICH TELLS US WHICH DATA YOU ARE TRYING TO UPDATE
IF YOU HAVE ANY QUERY PLEASE COMMENT DOWN BELOW
PLEASE GIVE A THUMBS UP
Add Answer to:
Question 13 1 pt Show the SQL needed to modify the phone number and contact for...
Please help me on the SQL queries, thank you so much. Write a query to display the title and publisher as well as the p...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
Oracle 12c SQL Chapter 12 Determine which orders were shipped to the same state as order...
Oracle 12c SQL Chapter 12 Determine which orders were shipped to the same state as order 1014. CREATE TABLE Orders (Order# NUMBER(4), Customer# NUMBER(4), OrderDate DATE NOT NULL, ShipDate DATE, ShipStreet VARCHAR2(18), ShipCity VARCHAR2(15), ShipState VARCHAR2(2), ShipZip VARCHAR2(5), ShipCost NUMBER(4,2), CONSTRAINT orders_order#_pk PRIMARY KEY(order#), CONSTRAINT orders_customer#_fk FOREIGN KEY (customer#) REFERENCES customers(customer#)); INSERT INTO ORDERS VALUES (1000,1005,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('02-APR-09','DD-MON-YY'),'1201 ORANGE AVE', 'SEATTLE', 'WA', '98114' , 2.00); INSERT INTO ORDERS VALUES (1001,1010,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'), '114 EAST SAVANNAH', 'ATLANTA', 'GA', '30314', 3.00); INSERT INTO ORDERS VALUES (1002,1011,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'),'58...
Oracle only database: DROP TABLE ORDERITEMS; DROP TABLE Orders; DROP TABLE BOOKAUTHOR; DRO...
oracle only
database:
DROP TABLE ORDERITEMS;
DROP TABLE Orders;
DROP TABLE BOOKAUTHOR;
DROP TABLE BOOKS;
DROP TABLE PROMOTION;
DROP TABLE AUTHOR;
DROP TABLE CUSTOMERS;
DROP TABLE PUBLISHER;
CREATE TABLE Customers
( Customer# NUMBER(4),
LastName VARCHAR2(10) NOT NULL,
FirstName VARCHAR2(10) NOT NULL,
Email VARCHAR(40),
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4),
Region CHAR(2),
CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#)
);
INSERT INTO CUSTOMERS
VALUES (1001, 'MORALES', 'BONITA', '[email protected]', 'P.O.
BOX 651', 'EASTPOINT', 'FL', '32328', NULL, 'SE');
INSERT INTO CUSTOMERS
VALUES...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
oracle only
database:
DROP TABLE ORDERITEMS;
DROP TABLE Orders;
DROP TABLE BOOKAUTHOR;
DROP TABLE BOOKS;
DROP TABLE PROMOTION;
DROP TABLE AUTHOR;
DROP TABLE CUSTOMERS;
DROP TABLE PUBLISHER;
CREATE TABLE Customers
( Customer# NUMBER(4),
LastName VARCHAR2(10) NOT NULL,
FirstName VARCHAR2(10) NOT NULL,
Email VARCHAR(40),
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4),
Region CHAR(2),
CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#)
);
INSERT INTO CUSTOMERS
VALUES (1001, 'MORALES', 'BONITA', 'Most questions answered within 3 hours.
-
4. What are the two possible products of the
intramolecular hemiacetal formation of linear glucose?
5. ...
asked 18 minutes ago -
The opportunity cost of attending university is likely to
include all except which of the following?...
asked 20 minutes ago -
Consider the following regular
expression: (a*bc+d*e)*
Transform this regular expression to an NFA, from
there to...
asked 17 minutes ago -
1. The Janjua Company had the following account balances at
1/1/16: Common Stock $50,000 Treasury Stock...
asked 18 minutes ago -
A solution with maximum solute that can dissolve and remain
stable is
saturated
unsaturated
miscible
supersaturated
asked 23 minutes ago -
Describe how you would make 100ml of a 10mmol glucose
standard
asked 23 minutes ago -
Zahn Corp.'s comparative balance sheet at December 31, 20x5 and
20x4, reported accumulated depreciation balances of...
asked 23 minutes ago -
How many milliliters of 5.6 M NaOH are needed to neutralize 3.9
mL of a 6.6...
asked 35 minutes ago -
Will dislike
if you don't code efficiently, you must have knowledge of
next.js,vue.js,immutable.js,react,js.
Develop an api...
asked 41 minutes ago -
When financial statements are converted to percentages, they are
referred to as:
A. Percent of change...
asked 42 minutes ago -
16) Which of the following is not a way to reduce the
government's budget
deficit
A)...
asked 1 hour ago -
At some time, a charged particle with q = −1.24×10−8C is moving
with instantaneous velocity v...
asked 1 hour ago