/SQL/Inserting data into different tables at once in oracle 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');

Source: stackoverflow.com

Similar codes

0 vote124 views1 answer
Google cloud sql postgres url example
SQL
-1 vote124 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote119 views1 answer
Mysql docker image arjun
SQL
0 vote112 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote131 views1 answer
How to add mysql to path on termin after installation
SQL
10 votes101 views1 answer
Oracle dependency
SQL
1 vote118 views1 answer
Oracle drop temporary table
SQL
0 vote131 views1 answer
Delet all record statment sql
SQL
0 vote130 views1 answer
Docker open terminal mysql server
SQL
0 vote113 views1 answer
How to fetch unique records from two tables
SQL