Hello, Could anyone one please tell me the purpose of using pl/sql tables such as index by tables, nested tables and varray. At what scenario we decide "okey.. Using pl/sql table concepts here is a good choice".. I am not actually looking for the syntax and all as plenty of them available in may websites. I need to know why we have to use and what are the advantages? and what could be the better "instead of" option? Thanks.