Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    12

    Unanswered: Input/output help? (Oracle 9)

    Hi there stuck on script which requires SQL to Produce a listing in chronological order of all details except description of any work of art acquired during a particular month. The month details are to be input from the keyboard.I'm unsure of how to do the input script code.

    any ideas for this?

    Thx

  2. #2
    Join Date
    Jan 2004
    Posts
    9
    select * from your_table where to_char(your_date_column,'MM') = &Month;

    Hope this helps,

    Gerrit-Jan Linker
    Author of SQL*XL: the Excel to databases bridge
    www.oraxcel.com

Posting Permissions

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