>>Can you create a VIEW from VIEW?
>>If so, how?
>
>Probably you can using some interim tables, but the idea is really stupid. You better create one more view from the same tables, or even common parameterized view.
The reason why I asked is...
I created a view(myview) from a certain group of records selected by the user...
Now the user wants to sort on myview...
That's why I asked if you Can create a VIEW from VIEW?
How do I sort on myview with myview being UPDATABLE.