I have checked a lot before i put this, i want toknow if we can have associate array in select query? As far as i know we can have nested tables and varrays in the select query?
Can someone please give an exapme of Associate arrays in select statment. As per the defination of Associative array's they are created only on pl/sql block or some package and cannot be stored in DB as object. so can we put associative arrya in slect query of a procedure?