I am reverse-engineering the schema of an Oracle database. I have a table and I created a function-based index on it.
DROP TABLE Fbi_tab;
CREATE TABLE Fbi_tab (
a INTEGER,
b INTEGER,
c INTEGER
);
CREATE INDEX Idx ON Fbi_tab (a+b*(c-1), a, b);
How can I generate the DDL used to create this index?
Best Answer
You can use DBMS_METADATA package.
For details: Oracle Documentation
DBMS_METADATA