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

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