Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Cursor and table shows as the same when display status
If you do a SQL * from a table into a cursor (which would result in the resultant being identical to the FROM table), doing display status shows the (FROM table) being open (which is correct) and the identity of the cursor is identical to the open table except that it shows a different alias and is readonly. If the exected SQL resultant is filtered and the resultant is not identical, the identity of the cursor is different. I was under the impression that a cursor always had an identity of its own!
Can somebody explain why this is happening?
Suivant
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