I got following question on an interview:
Which SQL mechanisms allow user to browse tables sequentially?
Cursor is a good example - but I don't think you could really argue that Cursors are truely a part of SQL - rather they just tend to come bolted in with procedural languages used on database servers - like pl/SQL and T-SQL.
You could also make an argument for Recordsets, Dynasets, DataTables and DataViews, but those aren't part of SQL itself either.
They might be referring to ORDER BY with a sequential field on the table, but if so, they've not phrased their question very well...
Martin.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With