Difference between Parameters and Select-Options

Hi ,

I am new to ABAP and I searched some articles in SDN,I didn't find the answer.

The question was , in parameters if we didn't give any value then it didn't retrieve data from data base.select query fails,but in select-options case

if we didn't give any value it fetches the entire table.What is the reason for this.

Regards

Shek