This topic contains a solution. Click here to go to the answer
« previous next »

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

kwoodring

  • Hero Member
  • *****
  • Posts: 560
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
:D TYSM

steff9894

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

« previous next »
 

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

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

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

A nurse adjusts the rate of a client’s IV. A nurse adjusts the rate of a client’s IV.
40.03 Contact With Enviroment 40.03 Contact With Enviroment
For ice massage, ice is frozen in a cylindrical container or a paper cup (A). The top half of the cu For ice massage, ice is frozen in a cylindrical container or a paper cup (A). The top half of the cu
Contact dermatitis resulting from poison ivy. Contact dermatitis resulting from poison ivy.
Greet a First-Time Client With a Firm Handshake. Greet a First-Time Client With a Firm Handshake.
Circular clockwise pattern. Gently lay a hand on the abdomen to establish contact. Apply effleurage ... Circular clockwise pattern. Gently lay a hand on the abdomen to establish contact. Apply effleurage ...
Video: Wound Repair Animation

For a complete list of videos, visit our video library