Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: SQL table recreation

by dragonchild (Archbishop)
on Jan 05, 2005 at 13:50 UTC ( #419612=note: print w/replies, xml ) Need Help??


in reply to SQL table recreation

SQL statements are just pieces of text. If you're looking to create templated text, you will want to break the targets up into what's shared and what differs. Then, build your pieces as needed.

Often, I will use HTML::Template to build template files. I had very good success with this when I needed to build auditing tables in Oracle. Don't be fooled by the HTML:: part - HTML::Template is an excellent generic templating solution. It just so happens that its most common usage is HTML.

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://419612]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (10)
As of 2020-01-27 21:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?