Did I miss something? Wouldn't this be the perfect place for a PL/SQL cursor? Create cursor mytem as select * from table; Very dynamic. Nothing static about it at all. There are many ways to skin the cat. People should use what they're comfortable with. Though some methods do, in fact, work better than others. -- //www.freelists.org/webpage/oracle-l