select to generate create syntax

For a sample script to create tablespaces based on a simple select check out:

http://www.nsa.no/222/script-genereate-create-bigfile-tablespace-statements