PL/SQL (MOSC)

MOSC Banner

Retrieving or deleting a specific row from a nested table

edited Sep 7, 2013 9:01AM in PL/SQL (MOSC) 5 commentsAnswered
 Hi,There is a requirement where in i need to use nested tables concept.
that is table whose specific column will again hold multiple rows and columns data using object types and this would continue further.
In this scenario is there a way for us to retrieve a specific record or delete a specific record.

Will there be any difference in retrieving/deleting process if i use object type and table type.

If there is some example which can explain above scenario , it would be grateful.

Uday 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center