1

Hello I am trying to export some indexes from a schema and I am using dbms_metadata.get_ddl

So far the indexes are exported like this

CREATE UNIQUE INDEX "TEST" ON "TABLE" (ROUND("COLUMN1") , NVL("COLUMN2",0) , NVL("COLUMN3",0) , "YEAR" , "DAY");  but I would like after each column to specify ASC/DESC

So the index would look like this:

CREATE UNIQUE INDEX "TEST" ON "TABLE" (ROUND("COLUMN1") ASC, NVL("COLUMN2",0) ASC, NVL("COLUMN3",0) ASC, "YEAR" ASC, "DAY" ASC);

Is there any way I can configure it to look like this?

Thank you!

0 Answers0