Oracle Collections equivalent in snowflake

Experts,

We are in process of migrating Oracle PL/SQL procedure to Snowflake java script. We were able to migrate close to 80 % of functionality successfully. However we are struck with oracle collection and record type, unable to find equivalent functionality in snowflake. can please shred some light on this.

Oracle Code:

TYPE first_typ IS TABLE OF students.forename%TYPE INDEX BY PLS_INTEGER;

marks.mark%TYPE;

SELECT * BULK COLLECT INTO all_students FROM students;

Thanks, Gopi

https://stackoverflow.com/questions/65376971/oracle-collections-equivalent-in-snowflake December 20, 2020 at 12:41PM