Difference between varray and nested table - OracleConnections2024-03-28T18:52:30Zhttp://www.oracleconnections.com/forum/topics/difference-between-varray-and-nested-table?commentId=6612035%3AComment%3A45846&feed=yes&xn_auth=noVarrays are generally dense ,…tag:www.oracleconnections.com,2014-01-30:6612035:Comment:459432014-01-30T14:11:03.811ZGeorgina Valtierrahttp://www.oracleconnections.com/profile/GeorginaValtierra
<p><span>Varrays are generally dense , that mean you cannot delete elements of the varray.But the elements of the Nested Table are generally sparse in nature and hence the elements can be deleted in between using the delete function. Varrays have fixed length (length declared during the declaration time), while Nested table can have unlimited length.</span></p>
<p><span>Varrays are generally dense , that mean you cannot delete elements of the varray.But the elements of the Nested Table are generally sparse in nature and hence the elements can be deleted in between using the delete function. Varrays have fixed length (length declared during the declaration time), while Nested table can have unlimited length.</span></p> Both are type of collections…tag:www.oracleconnections.com,2014-01-30:6612035:Comment:458492014-01-30T14:09:55.469ZCreola Mastrohttp://www.oracleconnections.com/profile/CreolaMastro
<p><span>Both are type of collections in Oracle. In Varray because its not stored in database</span><span> columns so no DML operation can be implemented but on other hand as Nested tables we can perform DML operations</span></p>
<p><span>Both are type of collections in Oracle. In Varray because its not stored in database</span><span> columns so no DML operation can be implemented but on other hand as Nested tables we can perform DML operations</span></p> They are Oracle data types th…tag:www.oracleconnections.com,2014-01-30:6612035:Comment:458462014-01-30T14:09:11.004ZNelda Kalinahttp://www.oracleconnections.com/profile/NeldaKalina
<p><span>They are Oracle data types </span><br/><span>those who knoww any language like C and java then it is easy to understand the concept of Varray, as it is related to ARRAY structure of C or java language. </span><br/><br/><span>where as Nested Table concept is related to Struct data type of C or java langauge. </span></p>
<p><span>They are Oracle data types </span><br/><span>those who knoww any language like C and java then it is easy to understand the concept of Varray, as it is related to ARRAY structure of C or java language. </span><br/><br/><span>where as Nested Table concept is related to Struct data type of C or java langauge. </span></p>