How to insert data into multiple tables through SQL Query

insert all into e2 (empno,ename) values (9097,'xxxxx')
               into e3 (deptno,dname) values (50,'developer')
               select 1 from dual;