Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2002
    Posts
    22

    Unanswered: using pl/sql table

    hi guys,
    how would i write the following sql statments using pl/sql table?

    SELECT to_char (orderdate, 'yyyymm') as ORDERDATE, SUM(total) as SUM, ordid, custid, shipdate
    FROM ORD
    WHERE ORDERDATE >= to_date ('198701','yyyymm')
    group by orderdate,ordid, custid, shipdate
    having SUM(total) > 1000

    THANKS
    ***

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: using pl/sql table

    Originally posted by mark00189
    hi guys,
    how would i write the following sql statments using pl/sql table?

    SELECT to_char (orderdate, 'yyyymm') as ORDERDATE, SUM(total) as SUM, ordid, custid, shipdate
    FROM ORD
    WHERE ORDERDATE >= to_date ('198701','yyyymm')
    group by orderdate,ordid, custid, shipdate
    having SUM(total) > 1000

    THANKS
    ***
    HUH?
    "sql statements"?
    I only see one SQL statement.
    I guess I need to go have another scotch so I can see more statements.
    From where did "using pl/sql table" become relevant to this discussion?
    What problem are you REALLY trying to solve?
    I think you need to use mauve database to get the desired solution.

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    I hope you are trying to convert your SQL statements into Pl\SQL. Nothing to do with Pl\SQL Tables. Am I right?
    SATHISH .

  4. #4
    Join Date
    Nov 2002
    Posts
    22
    i have to use pl/sql table for that h/w...

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    "h/w"?
    hardware?
    homework?
    If it is homework, go ask your instructor for assistance & forgiveness.

  6. #6
    Join Date
    Nov 2002
    Posts
    22

    Angry

    anacedent...

    u moron, drunk senior...if u dont know the ans...to any of this why dont u just go & drink your scotch & stop wasting your time by wrtting smthing stupid....u mk your self look stupid..it was clear that 1 posting had typo of extra 's' & for the 2nd one why would it be hardware? even a small kid could figure out thats homework...

    do some other useful stuff than just type bogus stuff!!!

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Asked & answered.

    Go see the instructor, ask forgiveness, stay awake in class, take good/better notes in the future and when all else fails RTFM!

    Nobody here is going to do your homework for you.
    How do you expect to learn anything when you can't or won't
    use your brain? What do you plan on doing after graduation;
    come back to this list to get others to supply you with answers
    for which your employer is already paying you?

    If you'd my assistance, my consulting rate is $150/hour (USD);
    and I'll guarentee my work so you will get a passing grade on it.

    HAND!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •