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 66 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


alvinum

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

 

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

For a complete list of videos, visit our video library