Home » RDBMS Server » Server Administration » unique index on pl/sql tables
unique index on pl/sql tables [message #369726] Mon, 28 August 2000 04:47 Go to next message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
Is it possible to create an unique index on a pl/sql tables. If yes how? IF no how shall I check for the duplicate rows is a pl/sql tables.
Re: unique index on pl/sql tables [message #369728 is a reply to message #369726] Wed, 30 August 2000 08:41 Go to previous message
SureshJ
Messages: 4
Registered: August 2000
Junior Member
PL/SQL tables are by default indexed by a binary integer and cannot have a unique index on them as in a DB table. You have to use program logic and PL/SQL table built-ins such as

.FIRST,

.LAST,

.PRIOR,

.NEXT,
to loop through the table in order to check for duplicity in pl/sql tables. These built-ins will help you to have the search done in the most minimal time because they take advantage of a pl/sql table's sparseness and make traversal easy than conventional looping!!

I hope that helps.

Cheers.
SureshJ

PS :- Steven Feurestein's book will be really helpful in this regard. Or visit www.revealnet.com/pipelines/ and browse around for material on these.
Previous Topic: triggers and C functions
Next Topic: can Sequence be generated using JUST ome select statement...
Goto Forum:
  


Current Time: Tue Oct 20 10:18:05 CDT 2020