Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Unanswered: oracle sqlplus statements

    Hi I'm a new oracle db user, can someone help me with the two following oracle statements?

    May someone can help me with these two statements.
    1. Format the cost of course number 330 to display the cost with a leading dollar sign, a comma to separate the thousand, and include cents.

    SQL> SELECT COST, COURSE_NO
    FROM COURSE
    WHERE COST= LIKE'%$9,999.00%', COURSE_NO = 330;

    Getting error msg line 3 missing expression.

    2. Display the course, section id, and starting date and time for sections
    that are taught on May 4, 1999.

    SELECT
    FROM COURSE
    WHERE

    I could use some ideas on the two above statements.

    New in oracle db,

    Thanks,

    R.Thomas

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://tahiti.oracle.com
    http://download.oracle.com/docs/cd/B...b14357/toc.htm

    Why do you expect help on completing your homework assignment when we have no idea which fields/columns are in your table(s)?

    SQL> DESC COURSE
    --produces what output?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I understand you are a newbie (we all were once), but - statement(s) you wrote are a complete nonsense.

    What does question from your first assignment has to do with a query you wrote? Did you ever bother to read SELECT syntax? Ever heard of data formatting?

    The second question is even easier (actually, the answer is) than the first one.

    You must be either lazy or sloppy, because - even a newbie should be able write such a query. We can help, and we usually do, but what we do NOT do is write someone's homework.

Posting Permissions

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