I have to generate PL/SQL using Java. Most of the procedures are common. Only a few keeps changing.
- by blog
I have to generate PL-SQL code, with some common code(invariable) and a variable code. I don't want to use any external tools.
Some ways that I can think:
Can I go and maintain the common code in a template and with markers, where my java code will generate code in the markers and generate a new file.
Maintain the common code in static constant String and then generate the whole code in StringBuffer and at last write to file.
But, I am not at all satisfied with both the ideas. Can you please suggest any better ways of doing this or the use of any design patterns or anything?
Thanks in Advance.