How to insert record into two table at a time

[Rohullah]

I want to insert record into two table at a time.
For example i have two table student1 and student2 with the same structure
now i want to insert record into student1 the record of student1 should automiticlly insert into studendt2 table.

[ThatThatGuy]

Hello

I want to insert record into two table at a time.
for example i have two table student1 and student2 with the same structure
now i want to insert record into student1 the record of student1 should automiticlly insert into studendt2 table

looking forword.
thank you.
edit reply report

either you can use two insert queries or you can use triggers which will automatically insert record to the other table on insert...
refere to this tutorial

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/triggers.htm

[debasisdas]

Better use a procedure for the purpose.

[ThatThatGuy]

Hello

I want to insert record into two table at a time.
for example i have two table student1 and student2 with the same structure
now i want to insert record into student1 the record of student1 should automiticlly insert into studendt2 table

looking forword.
thank you.

Ya that could also be done