How to parse a SQL Script file
800344Mar 7 2005 — edited Mar 8 2005Dear all,
I would like to write a SQL excutor which extracts SQL statements from a SQL Script file, and then excutes them.
It seems very hard to parse any SQL script file which can be run by SQL plus.
My problem is that what kind of format that I should impose to the SQL script file so that the parsing can be simply implemented.
I would appreciate any idea to this end.
Pengyou