SQL

Inserting data into different tables at once in oracle sql

INSERT INTO table1 t1, table2 t2 
(t1.tid, t1.date, t1.title, t2.tid, t2.date, t2.user, t2.note)
VALUES (1,'01-JAN-15','title',1,'01-JAN-15','john','test note');

insert into one table from another table in oracle

insert into <table_name> select <fieldlist> from <tables>