look at EXECUTE IMMEDIATE to execute a dynamic sql string you create at run time, as indicated in your question.