In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR><BR>That's the only way I can think to do it in a database. More options ...