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


xthemafja

  • Member
  • Posts: 348
Reply 3 on: Yesterday
Gracias!

 

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

For a complete list of videos, visit our video library