Originally posted by reemagupta
It is a user input asking for the value of ID. Once you supply it with a valid value for the ID, it would return the output of teh query, try running in sql plus.
Also note... I rather don't-like this kind of approach because if the user types in a non-existent or invalid input, he often winds up looking at a blank report or a blank screen. (Plus the input-prompt he's had to respond to is often pretty cryptic.) This technique might be fine for a "data center internal-use-only" query but it's extremely obtuse when used in an end-user application.
Thank you. I am greatful for your responce.
Well, this query is going to be used internally within an asp page. The values which will be invoked are going to be generated and stored in a view and the the feild for this particular value will not be empty.
What could be a better way to do this. I am a beginner and would appreciate hints from you.