I have a huge bunch of table scripts that needs to be changed, example script below.
Need to change the NUMBER(10) TO NUMBER(38)
Add 2 columns in the end of the script.
CREATE_DT char(10) NULL,
UPDATE_DT char(10) NULL,
How can this be done in a script.
The pattern I see now is there is a '/' delimiter at the end of each statement, so that the script can be read and everything with the delimiter can be considered a chunk and them if a CREATE TABLE is found, read line by line, replace the number(10) to number(38) and for the last line since there is no comma, add a comma and insert the next 2 lines..Is this how this can be approached. Any other ideas ?