I am having two tables. and these two tables are related to one another. so now my question is I want to insert data into these two tables by using one query.

One option : using stored procedure u can insert

Hi,

Please, describe the relationship between the two tables.
What data should go in the second table when a record is inserted in the first table?

Best Regards,
Dimitar

in my view if u are an oracle user mens you may use trigger..

trigger is executed automatically when an event occurs in a database.

such events are select,delete,update...

syntax:
create or replace trigger <trigger-name> <before/after> <event-name> on <table-name>
---------
---------
end;