Oracle Database Discussions

I have a table which contains first_nm, middle_nm, last_nm field.
These fields are used in query search in the where clause frequently, however the respose time is slow. We do have function based indexes on these columns.

Can somebody guide me how can I create domain / text indexes on these text fields specially the last_nm?
Steps or any eg for how to create them will be very useful.
Also does anyone know if the test indexes are picked up in explain plan when a wild card serach using "like %test%" is performed.

Thanks a lot for your response.
dk