Oracle SQL query

5 pts.
Tags:
Oracle
SQL
How do I list the mid-western vendors (Illinois, Indiana, Iowa, Minnesota, Wisconsin)? Also display the vendor ID, name, contact name (first & last), city, and state. Use formatting and concatenation to reduce the space required for the contact and city (30 characters should be fine). Order the listing by the city within state.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    That's your homework. You should try to do it on your own.

    Show us what you have tried or done, and we can give you some pointers to help you complete it.
    85,480 pointsBadges:
    report
  • ToddN2000
    Sounds like homework. It is not too difficult a task. Try it and post your code here if you are still having issues. The best way to learn is try it. If you fail then asking for help is not a problem, we can help show you where you made the mistake and you can move forward.
    135,525 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: