FreeLists / oracle-l / Function - Based Indexes

[Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>]

Hi,
 
If an Index is created on a column using Function then how do you find out this 
information using Data Dictionary.
 
For example:
   create index tab1_idx1 on tab1(trim(lower(billaddress))) tablespace users;
 
Usually I export table without DATA to see Create Index syntax.
 
Please let me know if I can use any Data Dictionary.
 
Thanks
Muqthar Ahmed
 
 
 

                *       *       *       *       *       *       *       *       
*

The information contained in this E-mail message is privileged, confidential, 
and may be protected from disclosure; please be aware that any other use, 
printing,copying, 
disclosure or dissemination of this communication may be subject to legal 
restriction or sanction. If you think that you have received this E-mail 
message in error, please 
reply to the sender and delete it from your computer. Thank you.