Re: Query by parameter ( I got some tips)
Thanks for the suggetions.
1.Creating a view for each vendor type is not possible because there are number of vendor types,
increased or decreased while updations.
2.Using a stored procedure will work for SQL Server (and I think SyBase also ?) but not for oracle.
3.I can't use SELECT Statement directly on tables (as Cakkie and Iouri suggested) because of security reasons where every user connected to database server will make transaction through a stored procedure or an earlier created view.
I got some tips on getting recorset from oracle stored procedures. Please check out these links if you are interested.
http://support.microsoft.com/support.../Q229/9/19.asp
http://www.actionjackson.com/articles/20000127/