Function - Based Indexes

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Mon, 1 Mar 2004 13:05:45 -0500
Message-ID: <6362087FB073D41195B800D0B78284BE0621C838@mail01.corp.abwf.com>

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.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Mar 01 2004 - 12:08:21 CST