Re: Using an oracle view to store query results

MF> I have a php script that queries an oracle table and returns a list of MF> results. The problem is the list is too long. What I'd like to do is MF> create a view, this view would contain the results of the query. Then I MF> could set up next/previous buttons to move through the results. Check your oracle manual for view. It is something like Create View viewname ( select yada yada yada from yada where yada) You could create a view per person but the problem with this is that you could be creating a billion (seems like a lot :-) of views depending on the number of hits you get. AND there is no *easy* way to delete the view because you wont know when the user is through with the view. The Select/Limit *should not* re-select the table but simply work from the existing cursor .. Yes? I don't actually remember this but this info is in the docs somewhere. If you don't have the book handy go to oracle on line and browse their documentation -- DSig David Tod Sigafoos mailto:dsig@teleport.com Using 'The Bat' 1.48 Beta/8 ````` ( O O ) _______oOOo__( )__oOOo_______