No, this is not available in Sybase. And it seems to me this kind of thing will just add unnecessary complications and bad code where people will write loops to increment a subscript instead of doing a join between 2 tables.
Then again I've seen some bad code using a loop to retrieve values from the 2nd table.
This is at logical level like temporary or hash tables in T-SQL, however we can store the data in physical table.
Ok. I did have some experience working in PL SQL before but lost touch... What you are referring to is a close knit between PL/SQL and oracle. Its definitely not ANSI but its something more Oracle has accommodated in their PL/SQL... PL/SQL is definitely powerful than other tsql programs...
What you are trying to achieve could be easily done in something in perl for eg., for Sybase. but not in TSQL... Please understand Oracle PL/SQL is their own extension of ANSI but not industry standards... They tried to make PL/SQL as a programming language (which is pretty close enuf I dont deny it), to get monopoly and dependency of their product but nothing else...
So, you are going to have tough time finding equivalents when you program at other RDBMS