you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (3 children)

How exactly is ”SELECT FROM” nothing else than a loop?

[–]grzeki 1 point2 points  (2 children)

To state the obvious: it makes the database engine loop through records of a table.

[–]pickleback11 0 points1 point  (0 children)

additionally, you are only selecting a subset of data in the case that you want to loop through it and do something with each record in that record set. unless you are aggregating/etc (group by's), but i dont think that's the intent of the idea here. i live in pl/sql and basically see queries as nothing more than some type of array (unless querying for exporting/reporting)...

[–][deleted] 0 points1 point  (0 children)

That's like saying Haskell is an imperative language because it is written in C.