Hi All,

I am new with Oracle Text, I have some doubts regarding Oracle Text feature of Oracle, below are the list:

1 - What is Oracle Text

2 - Why we use Oracle Text, in which senario we need to use Oracle Text.

3 - What are the necessary setups need to be done in database before using Oracle Text.

4 - What are difference between Oracle Text query and normal search query

5 - What are the merits and demerits of Oracle Text to Database

6 - Is indexes created with Oracle Text are good for Database as compre to normal Indexes

Please provide a link where I can read alot of Oracle Text easly

Thanks