This topic contains a solution. Click here to go to the answer

Author Question: In Oracle, the statement used to retrieve client's contact with emails that end in net, from zip ... (Read 82 times)

kwoodring

  • Hero Member
  • *****
  • Posts: 560
In Oracle, the statement used to retrieve client's contact with emails that end in net,
  from zip codes 03223 and 03264, would be __________.
 
  Fill in the blanks with correct word

Question 2

In Oracle, the statement used to retrieve client's contacts with emails that are not from
  zip codes 03223 and 03264, would be __________.
 
  Fill in the blanks with correct word



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

dellikani2015

  • Sr. Member
  • ****
  • Posts: 332
Answer to Question 1

Select contact, email, zipcode From client Where email Like 'net' And (zipcode = '03223' Or zipcode = '03264')

Answer to Question 2

Select contact, email, zipcode From client Where zipcode Not In ('03223', '03264')




kwoodring

  • Member
  • Posts: 560
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


nyrave

  • Member
  • Posts: 344
Reply 3 on: Yesterday
Excellent

 

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

For a complete list of videos, visit our video library