Sudheer Bhat wrote:I don't think you can insert into two tables in a single SQL statement. Atleast the database(Oracle) I have worked on has no option to do so.
Oracle can insert into several tables at once in fact, at least from 9i on. Search for
Oracle multitable insert - or better look up Oracle's documentation of the INSERT statement. It's all there.
Your comments on the design is probably right. If the database is actually Oracle, sequences could be used to easily populate the tables, as I've already described
here. Assuming that the design is corrected first, that is.