--CELKO-- schrieb:

>>>I am a java programmer and a novice in databases. <<
>
>
> SQL is a declarative language. We do not like to write procedural code
> at all! We also do not have arrays; the ONLY data structure is a table.
> In short, your question pseudo-code makes no sense.

Makes no sense. For what is PL/SQL (Oracle) and Transact SQL in Sybase?
Because procedural code is not necessary? Sure, your code is 100% pure
non procedural.


> What we would look more like this:

> See? No loops, no if', just pure set-oriented operations. It will take
> you about a year of full-time SQL programming to un-learn procedural
> coding.

Sorry, nonsense.

Cheers,

Dietmar.