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 22 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
Excellent


debra928

  • Member
  • Posts: 342
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

For a complete list of videos, visit our video library