Updating method

21-Nov-2017 10:49

The database stores the rows of a nested table in no particular order.When you retrieve a nested table from the database into a PL/SQL variable, the rows are given consecutive subscripts starting at 1.A nested table type or varray type that is created at schema level (with the CREATE TYPE Statement) is stored in the database, and you can manipulate it with SQL statements.

When the remote database uses a collection method such as , it uses its own character order, which might be different from the order where the collection originated.

Using the same key with a different value changes the value.