ThanX for the Links. Just one clarification. my requirement needs the Table name to be changing. For eg. T1, T2, T3 etc. The number value appended is obtained at runtime. I beleive this can be done in a Procedure. But can I use a host variable for the table name in the embedded dynamic SQL?