Search Results

there are other statements in the file too e.g. CREATE TABLE. how would the above script look like?

this one worked for me! great! thank you!

couldn´t try the other one because i currntly don´t have gawk installed.

example:

-- TABLE001
CREATE UNIQUE INDEX ATABL001
ON TABLE001
(COLUMN1 ASC,
COLUMN2 ASC,
COLUMN3 ASC,
COLUMN4 ASC);
COMMIT;

CREATE INDEX BTABL001
ON...

Hi,
i want to extract the 'CREATE INDEX' or 'CREATE UNIQUE INDEX' statements from a ddl file and output each match to a separate file. i was looking around the net but couldn´t find anything.

a...