Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement