insert select mechanism in secondary index

Database
Not applicable

insert select mechanism in secondary index

Hi Guys,

Can anybody explain me how an insert and select work for a table with secondary index.Please explain with example(for both NUSI,USI).

Regards
Meenakshi