>>I was just looking for validation or experiance on the cursor vs the view. Is there a reason to do the extra coding to use a view when you don't need the extra features of a view over a cursor? I can create an updatable cursor too but it seems to me to be easier to go the view route when I need to update from a subset of data from tables....

---

>In that case you can better use a cursor like you said.
>Coding things you don't need is not usefull.
>
>But am i right that you also mean with cursor: select ..... into cursor mycursor

Yes, that is what I meant

Thanks for the replys