Oracle SQL query GODS help wanted on this problem...

Hawkeye-X

(1000+ posts) Send PM | Profile | Ignore

Tue Oct-14-03 04:57 PM
Original message

Oracle SQL query GODS help wanted on this problem...

Look at this:

select order_num, order_date from customer, orders, order_line
where customer.customer_num = orders.customer_num
and customer_name = 'Ferguson''s' and
orders.order_num = order_line.order_num
and order_line.part_num = part.part_num and
part.description = 'Gas Range';

I'm supposed to list the order number and order date for each
order that was placed by Ferguson's and that contains an order
for a Gas Range.

When I run this query, I get this error:

part.description = 'Gas Range'
     *
ERROR at line 6:
ORA-00904: invalid column name

Tell me what I'm doing wrong, so I don't look like a dufus.

Thanks!

Hawkeye-X

Printer Friendly | Permalink | | Top

jono

(1000+ posts) Send PM | Profile | Ignore

Tue Oct-14-03 05:00 PM
Response to Original message

1. You haven't included

Edited on Tue Oct-14-03 05:01 PM by jono

the parts table in your FROM list.

:hi:

edit: i meant the part table, not parts.

Printer Friendly | Permalink | | Top

Hawkeye-X

(1000+ posts) Send PM | Profile | Ignore

Tue Oct-14-03 05:03 PM
Response to Reply #1

3. Oh damn.

That worked.

Thanks!

Printer Friendly | Permalink | | Top

TrogL

(1000+ posts) Send PM | Profile | Ignore

Wed Oct-15-03 09:25 AM
Response to Reply #3

9. are you sure

you wanted to display that column?

Printer Friendly | Permalink | | Top

DK666

(727 posts) Send PM | Profile | Ignore

Tue Oct-14-03 05:03 PM
Response to Reply #1

4. You were too fast...

Missed that one...

Printer Friendly | Permalink | | Top

monkeyboy

(965 posts) Send PM | Profile | Ignore

Tue Oct-14-03 05:00 PM
Response to Original message

2. Try double quotes

The problem is somewhere in quote-ville.

Printer Friendly | Permalink | | Top

Bozola

(992 posts) Send PM | Profile | Ignore

Tue Oct-14-03 05:40 PM
Response to Original message

5. Oracle is the spawn of Satan

aka Larry Ellison.

Ick

Printer Friendly | Permalink | | Top

DS1

(1000+ posts) Send PM | Profile | Ignore

Tue Oct-14-03 05:53 PM
Response to Reply #5

6. true, but once you master it, it's the Buddy Lee of DBMSs

Can't bust it!

Printer Friendly | Permalink | | Top

Meshuga

(1000+ posts) Send PM | Profile | Ignore

Tue Oct-14-03 06:39 PM
Response to Reply #6

7. Poor kitty!

in your signature. :-)

Printer Friendly | Permalink | | Top

Bozola

(992 posts) Send PM | Profile | Ignore

Wed Oct-15-03 09:22 AM
Response to Reply #6

8. I suggest you better catch up on those CERT advisories...

I hope you don't use 9i RAS....

(industry rumor is that they were more than a little pissed off)

http://computerworld.com/newsletter/0,4902,83186,00.html?nlid=DM

Orbitz: Oracle to blame for site outage
-----------------------------------------

The online travel company promptly dumped the 9i RAC database software

Story by Linda Rosencrance

JULY 17, 2003 ( COMPUTERWORLD ) - Orbitz LLC, the airline-owned travel Web site, suffered an outage yesterday related to an Oracle database on which Orbitz operates the site, according to a spokeswoman for the Chicago-based company.
Orbitz spokeswoman Carol Jouzaitis said it was the most severe outage to hit the online operation since the site launched approximately two years ago.

Declining to go into detail about what happened, Jouzaitis said the site went down early yesterday morning and was back up very early today. She stressed that no customer data was lost or corrupted as a result of the outage.

"It was an database issue, and we decided to make an architectural change to the site, a change that will put us in a position to move forward with even higher reliability," Jouzaitis said. "The site is performing great now."

Jouzaitis said that as a result, Orbitz is no longer using Oracle Corp.'s 9i Real Application Clusters (RAC) database software.

An Oracle spokeswoman in a statement this afternoon stressed that no customer data was compromised by the outage.

"As with all Oracle customers, we worked closely together with our partners and Orbitz to resolve the issue as quickly as possible," she said. "No Orbitz customer data has been lost or corrupted as a result of the situation yesterday, and the site is again operational."

The Orbitz outage comes at a time when Oracle is touting its "unbreakable" software in an extensive marketing campaign. "Unbreakable" refers to a database that will not go down, even if the server or the site fails. Oracle is also in the midst of a hostile takeover of rival PeopleSoft and is trying to project a customer-friendly image.

Printer Friendly | Permalink | | Top

DU AdBot (1000+ posts)

Fri May 03rd 2024, 03:38 AM
Response to Original message

Advertisements [?]

Top

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.